Type in Google’s function list
Text functions
Functions that inspect, cut, join or convert text. Google prints 41 Text function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| ARABIC | ARABIC(roman_numeral) | Computes the value of a Roman numeral. |
| ASC | ASC(text) | Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. |
| CHAR | CHAR(table_number) | Convert a number into a character according to the current Unicode table. |
| CLEAN | CLEAN(text) | Returns the text with the non-printable ASCII characters removed. |
| CODE | CODE(string) | Returns the numeric Unicode map value of the first character in the string provided. |
| CONCATENATE | CONCATENATE(string1, [string2, ...]) | Appends strings to one another. |
| DOLLAR | DOLLAR(number, [number_of_places]) | Formats a number into the locale-specific currency format. |
| EXACT | EXACT(string1, string2) | Tests whether two strings are identical. |
| FIND | FIND(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text. |
| FINDB | FINDB(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text counting each double-character as 2. |
| FIXED | FIXED(number, [number_of_places], [suppress_separator]) | Formats a number with a fixed number of decimal places. |
| JOIN | JOIN(delimiter, value_or_array1, [value_or_array2, ...]) | Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. |
| LEFT | LEFT(string, [number_of_characters]) | Returns a substring from the beginning of a specified string. |
| LEFTB | LEFTB(string, num_of_bytes) | Returns the left portion of a string up to a certain number of bytes. |
| LEN | LEN(text) | Returns the length of a string. |
| LENB | LENB(string) | Returns the length of a string in bytes." |
| LOWER | LOWER(text) | Converts a specified string to lowercase. |
| MID | MID(string, starting_at, extract_length) | Returns a segment of a string. |
| MIDB | MIDB(string) | Returns a section of a string starting at a given character and up to a specified number of bytes. |
| PROPER | PROPER(text_to_capitalize) | Capitalizes each word in a specified string. |
| REGEXEXTRACT | REGEXEXTRACT(text, regular_expression) | Extracts matching substrings according to a regular expression. |
| REGEXMATCH | REGEXMATCH(text, regular_expression) | Whether a piece of text matches a regular expression. |
| REGEXREPLACE | REGEXREPLACE(text, regular_expression, replacement) | Replaces part of a text string with a different text string using regular expressions. |
| REPLACE | REPLACE(text, position, length, new_text) | Replaces part of a text string with a different text string. |
| REPLACEB | REPLACEB(text, position, num_bytes, new_text) | Replaces part of a text string, based on a number of bytes, with a different text string. |
| REPT | REPT(text_to_repeat, number_of_repetitions) | Returns specified text repeated a number of times. |
| RIGHT | RIGHT(string, [number_of_characters]) | Returns a substring from the end of a specified string. |
| RIGHTB | RIGHTB(string, num_of_bytes) | Returns the right portion of a string up to a certain number of bytes. |
| ROMAN | ROMAN(number, [rule_relaxation]) | Formats a number in Roman numerals. |
| SEARCH | SEARCH(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text. |
| SEARCHB | SEARCHB(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text counting each double-character as 2. |
| SPLIT | SPLIT(text, delimiter, [split_by_each], [remove_empty_text]) | Divides text around a specified character or string, and puts each fragment into a separate cell in the row. |
| SUBSTITUTE | SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) | Replaces existing text with new text in a string. |
| T | T(value) | Returns string arguments as text. |
| TEXT | TEXT(number, format) | Converts a number into text according to a specified format. |
| TEXTJOIN | TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) | Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. |
| TRIM | TRIM(text) | Removes leading and trailing spaces in a specified string. |
| UNICHAR | UNICHAR(number) | Returns the Unicode character for a number. |
| UNICODE | UNICODE(text) | Returns the decimal Unicode value of the first character of the text. |
| UPPER | UPPER(text) | Converts a specified string to uppercase. |
| VALUE | VALUE(text) | Converts a string in any of the date, time or number formats that Google Sheets understands into a number. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.