Text and Data Functions
ARRAYTOTEXT function
The ARRAYTOTEXT function returns a range of data as a text string.
ASC function
The ASC function changes full-width (double-byte) characters to half-width (single-byte) characters.
CHAR function
The CHAR function returns the ASCII character specified by a number.
CLEAN function
The CLEAN function removes all the nonprintable characters from the selected string.
CODE function
The CODE function returns the ASCII value of the specified character or the first character in a cell.
CONCATENATE function
The CONCATENATE function combines the data from two or more cells into a single one.
CONCAT function
The CONCAT function combines the data from two or more cells into a single one and replaces the CONCATENATE function.
DOLLAR function
The DOLLAR function converts a number to text using a currency format.
EXACT function
The EXACT function compares data in two cells and returns TRUE if the data are the same, and FALSE if not.
FIND/FINDB function
The FIND/FINDB function finds the specified substring within a string.
FIXED function
The FIXED function returns the text representation of a number rounded to a specified number of decimal places.
IMPORTRANGE function
The IMPORTRANGE function imports a range of cells from a specified spreadsheet.
LEFT function
The LEFT/LEFTB function extracts a substring from the specified string starting from the left character.
LEN/LENB function
The LEN/LENB function analyses the specified string and returns the number of characters it contains.
LOWER function
The LOWER function converts uppercase letters to lowercase in the selected cell.
MID function
The MID/MIDB function extracts characters from the specified string starting from any position.
NUMBERVALUE function
The NUMBERVALUE function converts text to a number in a locale-independent way.
PROPER function
The PROPER function converts the first character of each word to uppercase and all the remaining characters to lowercase.
REGEXTEST function
The REGEXTEST function checks whether any part of supplied text matches a regular expression pattern, returning TRUE or FALSE.
REPLACE function
The REPLACE/REPLACEB function replaces a set of characters, based on the number of characters and the start position you specify, with a new set of characters.
REPT function
The REPT function repeats the data in the selected cell as many times as you wish.
RIGHT function
The RIGHT/RIGHTB function extracts a substring from a string starting from the right-most character, based on the specified number of characters.
SEARCH function
The SEARCH/SEARCHB function returns the location of the specified substring in a string.
SUBSTITUTE function
The SUBSTITUTE function replaces a set of characters with a new one.
T function
The T function checks whether a value is text and returns the text itself, or a blank result if it is not text.
TEXT function
The TEXT function converts a value to text in the specified format.
TEXTJOIN function
The TEXTJOIN function combines the text from multiple ranges and/or strings with a delimiter you specify between each text value.
TRIM function
The TRIM function removes the leading and trailing spaces from a string.
UNICHAR function
The UNICHAR function returns the Unicode character that is referenced by the given numeric value.
UNICODE function
The UNICODE function returns the number (code point) corresponding to the first character of the text.
UPPER function
The UPPER function converts lowercase letters to uppercase in the selected cell.
VALUE function
The VALUE function converts a text value that represents a number to a number.
TEXTBEFORE function
The TEXTBEFORE function returns text occurring before delimiting characters.
TEXTAFTER function
The TEXTAFTER function returns text occurring after delimiting characters.
TEXTSPLIT function
The TEXTSPLIT function splits text strings through column and row delimiters.