Text Functions

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.

LOWER

Converts all letters in a text string to lowercase.

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 …

RIGHT

RIGHT returns the last character or characters in a text string, based on the number …

REPT

Repeats text a given number of times. Use REPT to fill a cell with a …

REPLACE

REPLACE replaces part of a text string, based on the number of characters you specify, …

MID

Returns a string of characters from the middle of a text string, given a starting …

BLANK

Returns a blank.

LEN

Returns the number of characters in a text string.

LEFT

Returns the specified number of characters from the start of a text string.

FORMAT

Converts a value to text according to the specified format.

FIXED

Rounds a number to the specified number of decimals and returns the result as text. …

FIND

Returns the starting position of one text string within another text string. FIND is case-sensitive.

EXACT

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. …

CONTAINSSTRINGEXACT

Returns TRUE or FALSE indicating whether one string contains another string.

CONTAINSSTRING