Excel text functions
Text functions in Excel, explained with live examples.
51 text functions in Excel — 38 documented in depth so far, the rest indexed below and landing every week.
Documented text functions
Syntax, examples, and the equivalent — ready now.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets
- DETECTLANGUAGEIdentifies the language of a specified textTextGoogle Sheets
- DOLLARConverts a number to text, using the $ (dollar) currency formatTextGoogle Sheets
- EXACTChecks to see if two text values are identicalTextGoogle Sheets
- FINDFinds one text value within another (case-sensitive)TextGoogle Sheets
- FIXEDFormats a number as text with a fixed number of decimalsTextGoogle Sheets
- LEFTReturns the leftmost characters from a text valueTextGoogle Sheets
- LENReturns the number of characters in a text stringTextGoogle Sheets
- LOWERConverts text to lowercaseTextGoogle Sheets
- MIDReturns a specific number of characters from a text string starting at the position you specifyTextGoogle Sheets
- NUMBERVALUEConverts text to number in a locale-independent mannerTextNo Google Sheets equivalent
- PROPERCapitalizes the first letter in each word of a text valueTextGoogle Sheets
- REGEXEXTRACTExtracts strings within the provided text that matches the patternTextGoogle Sheets
- REGEXREPLACEReplaces strings within the provided text that matches the pattern with replacementTextGoogle Sheets
- REGEXTESTDetermines whether any part of text matches the patternTextNo Google Sheets equivalent
- REPLACEReplaces characters within textTextGoogle Sheets
- REPTRepeats text a given number of timesTextGoogle Sheets
- RIGHTReturns the rightmost characters from a text valueTextGoogle Sheets
- SEARCHFinds one text value within another (not case-sensitive)TextGoogle Sheets
- SUBSTITUTESubstitutes new text for old text in a text stringTextGoogle Sheets
- TConverts its arguments to textTextGoogle Sheets
- TEXTFormats a number and converts it to textTextGoogle Sheets
- TEXTAFTERReturns text that occurs after given character or stringTextNo Google Sheets equivalent
- TEXTBEFOREReturns text that occurs before a given character or stringTextNo Google Sheets equivalent
- TEXTJOINCombines the text from multiple ranges and/or stringsTextGoogle Sheets
- TEXTSPLITSplits text strings by using column and row delimitersTextNo Google Sheets equivalent
- TRANSLATETranslates a text from one language to anotherTextNo Google Sheets equivalent
- TRIMRemoves spaces from textTextGoogle Sheets
- UNICHARReturns the Unicode character that is references by the given numeric valueTextGoogle Sheets
- UNICODEReturns the number (code point) that corresponds to the first character of the textTextGoogle Sheets
- UPPERConverts text to uppercaseTextGoogle Sheets
- VALUEConverts a text argument to a numberTextGoogle Sheets
- VALUETOTEXTReturns text from any specified valueTextNo Google Sheets equivalent
All Excel text functions
The full set — deep dives on the way.
- ASC
- Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
- BAHTTEXT
- Converts a number to text, using the ß (baht) currency format
- COPILOT
- Categorize, summarize, and generate text using Copilot
- DBCS
- Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
- FINDB
- Finds one text value within another (case-sensitive)
- JIS
- Changes half-width (single-byte) characters within a string to full-width (double-byte) characters
- LEFTB
- Returns the leftmost characters from a text value
- LENB
- Returns the number of characters in a text string
- MIDB
- Returns a specific number of characters from a text string starting at the position you specify
- PHONETIC
- Extracts the phonetic (furigana) characters from a text string
- REPLACEB
- Replaces characters within text
- RIGHTB
- Returns the rightmost characters from a text value
- SEARCHB
- Finds one text value within another (not case-sensitive)
More Excel function categories