CHAR

Returns the character for given ASCII value.

CLEAN

Converts all non-printable characters in an expression to spaces.

CODE

Returns the ASCII value for the first character in the expression.

CONCAT

Concatenates a text-expression into a single text value. Numbers are converted to text as needed.

DOLLAR

Converts numbers to currency-formatted text.

EXACT

Compares two text strings. If both are exact matches, the function returns TRUE.

FIND

Locates text within a text string, then returns the offset position of the first character in the string. The offset is expressed in the number of characters from the beginning of the searched text string. The first character in the string is 1, the second is 2, and so forth. This function is identical to the SEARCH function, except it IS case-sensitive.

FIXED

Converts a number to text with a fixed decimal place.

LEFT

Extracts the left-most characters from a text string.

LEN

Returns the number of characters in a text string.

LOWER

Converts a text string to lower case characters.

MID

Extracts the characters from a text string beginning at the offset value. The first character in a string has an offset of 1, the second 2, and so forth.

PROPER

Capitalizes the first letter of each sentence in a text string. Periods determine a sentence.

REPLACE

Replaces characters in a text string beginning at the offset position. The first character in the text string is always in offset position 1, the second is 2 and so forth.

REPT

Repeats a text-string a given number of times.

RIGHT

Extracts the right-most characters from a text string.

SEARCH

Locates text within a text string, then returns the offset position of the first character in the string. The offset is expressed in the number of characters from the beginning of the searched text string. The first character in the string is 1, the second is 2, and so forth. This function is identical to the FIND function, except it is NOT case-sensitive.

SUBSTITUTE

Swaps an instance of text in a string with new text.

T

Converts an expression to text. Automatically converts arguments to functions as needed. This function can return a number as text to overlap the number into adjacent cells.

TEXT

Formats an expression using a format template. The template must use the format conventions defined for gobeProductive.

TRIM

Trims all the spaces from a text string.

UPPER

Converts a text string to upper case characters.

VALUE

Converts an expression to a number format, if possible. Automatically converts arguments to functions as needed.