Text Functions

ASC

This function converts full-width (double-byte) characters to half-width (single-byte) characters.

BAHTTEXT

This function converts a number to Thai text and adds a suffix of "Baht"

CHAR

This function returns the character specified by a number.

CLEAN

This function removes all non-printable characters from text.

CODE

This function returns a numeric code to represent the first character in a text string. The returned code corresponds to the Windows character set (ANSI).

CONCAT

This function combines multiple text strings or numbers into one text string, the function will stay available for compatibility with "CONCATENATE" function.

CONCATENATE

This function combines multiple text strings or numbers into one text string.

DBCS

This function converts half-width (single-byte) characters to full-width (double-byte) characters.

DOLLAR

This function converts a number to text using currency format, with the decimals rounded to the specified place.

FIND

This function finds one text value within another and returns the text value’s position in the text you searched.

FINDB

This function finds one text value within another and returns the text value's position in the text you searched, and counts each double-byte characte as 2 when set DBCS as the default language.

FIXED

This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text.

JIS

This function converts half-width (single-byte) characters to full-width (double-byte) characters. Supported in Japanese and German language packages only.

LEFT

This function returns the specified leftmost characters from a text value, and based on the number of characters you specify.

LEFTB

This function returns the specified leftmost characters from a text value, and based on the number of bytes you specify.

LEN

This function returns the length of the number of characters in a text string.

LENB

This function returns the length of the number of bytes in a text string.

LOWER

This function converts text to lower case letters.

MID

This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of characters you specify.

MIDB

This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of bytes you specify.

PROPER

This function capitalizes the first letter in each word of a text string.

REPLACE

This function replaces part of a text string with a different text string, based on the number of characters you specify.

REPLACEB

This function replaces part of a text string with a different text string, based on the number of bytes you specify.

REPT

This function repeats text a specified number of times.

RIGHT

This function returns the specified rightmost characters from a text value, and based on the number of characters you specify.

RIGHTB

This function returns the specified rightmost characters from a text value, and based on the number of bytes you specify.

SEARCH

This function finds one text string in another text string and returns the index of the starting position of the found text.

SEARCHB

This function finds one text string in another text string and returns the index of the starting position of the found text, and counts each double-byte characte as 2 when set DBCS as the default language.

SJS.ENDWITH

This function returns whether the text ends with the given string.

SJS.STARTWITH

This function returns whether the text starts with the given string.

SUBSTITUTE

This function substitutes a new string for specified characters in an existing string.

T

This function returns the text in a specified cell.

TEXT

This function formats a number and converts it to text.

TEXTAFTER

This function returns text after delimiting characters.

TEXTBEFORE

This function returns text before delimiting characters.

TEXTJOIN

This function combines multiple ranges and/or strings into one text, and the text includes a delimiter you specify between each text value.

TEXTSPLIT

This function splits text into rows or columns using delimiters.

TRIM

This function removes extra spaces from a string and leaves single spaces between words.

UNICHAR

This function returns the Unicode character of a given numeric reference.

UNICODE

This function returns the number corresponding to the first character of the text.

UPPER

This function converts text to uppercase letters.

VALUE

This function converts a text string that is a number to a numeric value.