Archive

CLOSINGBALANCEMONTH

Evaluates the expression at the last date of the month in the current context.

VALUE

Converts a text string that represents a number to a number.

UPPER

Converts a text string to all uppercase letters.

UNICODE

Returns the number (code point) corresponding to the first character of the text.

UNICHAR

Returns the Unicode character referenced by the numeric value.

TRIM

Removes all spaces from text except for single spaces between words.

SUBSTITUTE

Replaces existing text with new text in a text string.

SEARCH

Returns the number of the character at which a specific character or text string is first found, reading left to right. Search is case-insensitive and accent sensitive.

RIGHT

RIGHT returns the last character or characters in a text string, based on the number of characters you specify.