This function removes unwanted spaces from a piece of text. The spaces before and after the text will be removed completely. Multiple spaces within the text will be trimmed to a single space

This function removes any non-printable characters from text. These non-printing characters are often found in data which has been imported from other systems such as database imports from mainframes.

This function calculates the value of a number, irrespective of whether it is positive or negative.

This function scans down the row headings at the side of a table to find a specified item. When the item is found, it then scans across to pick a cell entry.

This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

This function counts the number of numeric or text entries in a list. It will ignore blanks.

This function converts the first letter of each word to uppercase, and all subsequent letters are converted to lower case.

This function picks the highest value from a list of data.

This function counts the number of characters, including spaces and numbers, in a piece of text.

This function adds the value of items which match criteria set by the user.

This function tests a condition.

If the condition is met it is considered to be TRUE.

If the condition is not met it is considered as FALSE.

Depending upon the result, one of two actions will be carried out.