Excel text functions
Text functions in Excel, explained with live examples.
51 text functions in Excel — 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 Excel text functions
The full set — deep dives on the way.
- ARRAYTOTEXT
- Returns an array of text values from any specified range
- 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
- CHAR
- Returns the character specified by the code number
- CLEAN
- Removes all nonprintable characters from text
- CODE
- Returns a numeric code for the first character in a text string
- CONCAT
- Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
- CONCATENATE
- Joins several text items into one text item
- 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
- DETECTLANGUAGE
- Identifies the language of a specified text
- DOLLAR
- Converts a number to text, using the $ (dollar) currency format
- EXACT
- Checks to see if two text values are identical
- FINDB
- Finds one text value within another (case-sensitive)
- FIXED
- Formats a number as text with a fixed number of decimals
- JIS
- Changes half-width (single-byte) characters within a string to full-width (double-byte) characters
- LEFT
- Returns the leftmost characters from a text value
- LEFTB
- Returns the leftmost characters from a text value
- LEN
- Returns the number of characters in a text string
- LENB
- Returns the number of characters in a text string
- LOWER
- Converts text to lowercase
- MID
- Returns a specific number of characters from a text string starting at the position you specify
- MIDB
- Returns a specific number of characters from a text string starting at the position you specify
- NUMBERVALUE
- Converts text to number in a locale-independent manner
- PHONETIC
- Extracts the phonetic (furigana) characters from a text string
- PROPER
- Capitalizes the first letter in each word of a text value
- REGEXEXTRACT
- Extracts strings within the provided text that matches the pattern
- REGEXREPLACE
- Replaces strings within the provided text that matches the pattern with replacement
- REGEXTEST
- Determines whether any part of text matches the pattern
- REPLACE
- Replaces characters within text
- REPLACEB
- Replaces characters within text
- REPT
- Repeats text a given number of times
- RIGHT
- Returns the rightmost characters from a text value
- RIGHTB
- Returns the rightmost characters from a text value
- SEARCH
- Finds one text value within another (not case-sensitive)
- SEARCHB
- Finds one text value within another (not case-sensitive)
- SUBSTITUTE
- Substitutes new text for old text in a text string
- T
- Converts its arguments to text
- TEXT
- Formats a number and converts it to text
- TEXTAFTER
- Returns text that occurs after given character or string
- TEXTBEFORE
- Returns text that occurs before a given character or string
- TEXTJOIN
- Combines the text from multiple ranges and/or strings
- TEXTSPLIT
- Splits text strings by using column and row delimiters
- TRANSLATE
- Translates a text from one language to another
- TRIM
- Removes spaces from text
- UNICHAR
- Returns the Unicode character that is references by the given numeric value
- UNICODE
- Returns the number (code point) that corresponds to the first character of the text
- UPPER
- Converts text to uppercase
- VALUE
- Converts a text argument to a number
- VALUETOTEXT
- Returns text from any specified value
More Excel function categories