Google Sheets text functions
Text functions in Google Sheets, explained with live examples.
41 text functions in Google Sheets — 1 documented in depth so far, the rest indexed below and landing every week.
Documented text functions
Syntax, examples, and the equivalent — ready now.
All Google Sheets text functions
The full set — deep dives on the way.
- ARABIC
- Computes the value of a Roman numeral.
- ASC
- Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.
- CHAR
- Convert a number into a character according to the current Unicode table.
- CLEAN
- Returns the text with the non-printable ASCII characters removed.
- CODE
- Returns the numeric Unicode map value of the first character in the string provided.
- CONCATENATE
- Appends strings to one another.
- DOLLAR
- Formats a number into the locale-specific currency format.
- EXACT
- Tests whether two strings are identical.
- FINDB
- Returns the position at which a string is first found within text counting each double-character as 2.
- FIXED
- Formats a number with a fixed number of decimal places.
- JOIN
- Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
- LEFT
- Returns a substring from the beginning of a specified string.
- LEFTB
- Returns the left portion of a string up to a certain number of bytes. .
- LEN
- Returns the length of a string.
- LENB
- Returns the length of a string in bytes." .
- LOWER
- Converts a specified string to lowercase.
- MID
- Returns a segment of a string.
- MIDB
- Returns a section of a string starting at a given character and up to a specified number of bytes. .
- PROPER
- Capitalizes each word in a specified string.
- REGEXEXTRACT
- Extracts matching substrings according to a regular expression.
- REGEXMATCH
- Whether a piece of text matches a regular expression.
- REGEXREPLACE
- Replaces part of a text string with a different text string using regular expressions.
- REPLACE
- Replaces part of a text string with a different text string.
- REPLACEB
- Replaces part of a text string, based on a number of bytes, with a different text string. .
- REPT
- Returns specified text repeated a number of times.
- RIGHT
- Returns a substring from the end of a specified string.
- RIGHTB
- Returns the right portion of a string up to a certain number of bytes. .
- ROMAN
- Formats a number in Roman numerals.
- SEARCH
- Returns the position at which a string is first found within text.
- SEARCHB
- Returns the position at which a string is first found within text counting each double-character as 2.
- SPLIT
- Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
- SUBSTITUTE
- Replaces existing text with new text in a string.
- T
- Returns string arguments as text.
- TEXT
- Converts a number into text according to a specified format.
- TEXTJOIN
- Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.
- TRIM
- Removes leading and trailing spaces in a specified string.
- UNICHAR
- Returns the Unicode character for a number. .
- UNICODE
- Returns the decimal Unicode value of the first character of the text.
- UPPER
- Converts a specified string to uppercase.
- VALUE
- Converts a string in any of the date, time or number formats that Google Sheets understands into a number.
More Google Sheets function categories