Google Sheets text functions
Text functions in Google Sheets, explained with live examples.
41 text functions in Google Sheets — 33 documented in depth so far, the rest indexed below and landing every week.
Documented text functions
Syntax, examples, and the equivalent — ready now.
- ARABICComputes the value of a Roman numeral.TextExcel
- CHARConvert a number into a character according to the current Unicode table.TextExcel
- CLEANReturns the text with the non-printable ASCII characters removed.TextExcel
- CODEReturns the numeric Unicode map value of the first character in the string provided.TextExcel
- CONCATENATEAppends strings to one another.TextExcel
- DOLLARFormats a number into the locale-specific currency format.TextExcel
- EXACTTests whether two strings are identical.TextExcel
- FINDReturns the position at which a string is first found within text.TextExcel
- FIXEDFormats a number with a fixed number of decimal places.TextExcel
- JOINConcatenates the elements of one or more one-dimensional arrays using a specified delimiter.TextNo Excel equivalent
- LEFTReturns a substring from the beginning of a specified string.TextExcel
- LENReturns the length of a string.TextExcel
- LOWERConverts a specified string to lowercase.TextExcel
- MIDReturns a segment of a string.TextExcel
- PROPERCapitalizes each word in a specified string.TextExcel
- REGEXEXTRACTExtracts matching substrings according to a regular expression.TextExcel
- REGEXMATCHWhether a piece of text matches a regular expression.TextNo Excel equivalent
- REGEXREPLACEReplaces part of a text string with a different text string using regular expressions.TextExcel
- REPLACEReplaces part of a text string with a different text string.TextExcel
- REPTReturns specified text repeated a number of times.TextExcel
- RIGHTReturns a substring from the end of a specified string.TextExcel
- ROMANFormats a number in Roman numerals.TextExcel
- SEARCHReturns the position at which a string is first found within text.TextExcel
- SPLITDivides text around a specified character or string, and puts each fragment into a separate cell in the row.TextNo Excel equivalent
- SUBSTITUTEReplaces existing text with new text in a string.TextExcel
- TReturns string arguments as text.TextExcel
- TEXTConverts a number into text according to a specified format.TextExcel
- TEXTJOINCombines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.TextExcel
- TRIMRemoves leading and trailing spaces in a specified string.TextExcel
- UNICHARReturns the Unicode character for a number.TextExcel
- UNICODEReturns the decimal Unicode value of the first character of the text.TextExcel
- UPPERConverts a specified string to uppercase.TextExcel
- VALUEConverts a string in any of the date, time or number formats that Google Sheets understands into a number.TextExcel
All Google Sheets text functions
The full set — deep dives on the way.
- ASC
- Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.
- FINDB
- Returns the position at which a string is first found within text counting each double-character as 2.
- LEFTB
- Returns the left portion of a string up to a certain number of bytes.
- LENB
- Returns the length of a string in bytes.
- MIDB
- Returns a section of a string starting at a given character and up to a specified number of bytes.
- REPLACEB
- Replaces part of a text string, based on a number of bytes, with a different text string.
- RIGHTB
- Returns the right portion of a string up to a certain number of bytes.
- SEARCHB
- Returns the position at which a string is first found within text counting each double-character as 2.
More Google Sheets function categories