Excel function category
Excel Text Functions
Reference pages for text formulas used to clean imported data, extract characters, compare strings, and build readable worksheet output.
Explore Excel data cleanup guides41 functions
ARRAYTOTEXT
Text
Convert an array to readable text or a strict representation that records its rows and columns.
Syntax
ARRAYTOTEXT(array, [format])ASC
Text
Convert full-width DBCS characters to half-width single-byte characters.
Syntax
ASC(text)BAHTTEXT
Text
Convert a number to Thai text and append the Baht currency suffix.
Syntax
BAHTTEXT(number)CHAR
Text
Return the character represented by a numeric character code.
Syntax
CHAR(number)CLEAN
Text
Remove nonprintable characters from imported or copied text.
Syntax
CLEAN(text)CODE
Text
Return the numeric code for the first character in a text string.
Syntax
CODE(text)CONCAT
Text
Join text from multiple cells or ranges into one string without adding a delimiter.
Syntax
CONCAT(text1, [text2], ...)CONCATENATE
Text
Join multiple text values into a single text string.
Syntax
CONCATENATE(text1, [text2], ...)DETECTLANGUAGE
Text
Identify the language of text and return its language code using Microsoft Translation Services.
Syntax
DETECTLANGUAGE(text)DOLLAR
Text
Convert a number to text in currency format with configurable rounding.
Syntax
DOLLAR(number, [decimals])EXACT
Text
Compare two text strings and return TRUE only when they match exactly.
Syntax
EXACT(text1, text2)FIND
Text
Return the starting position of one text string inside another, with case-sensitive matching.
Syntax
FIND(find_text, within_text, [start_num])FIXED
Text
Round a number, format it as text, and optionally suppress thousands separators.
Syntax
FIXED(number, [decimals], [no_commas])LEFT
Text
Return the first character or characters from a text string.
Syntax
LEFT(text, [num_chars])LEN
Text
Return the number of characters in a text string.
Syntax
LEN(text)LOWER
Text
Convert all letters in a text string to lowercase.
Syntax
LOWER(text)MID
Text
Return characters from the middle of a text string based on a start position and length.
Syntax
MID(text, start_num, num_chars)NUMBERVALUE
Text
Convert numeric text to a number using the decimal and grouping separators in the source.
Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])PHONETIC
Text
Extract the phonetic furigana characters from a text string or referenced cell.
Syntax
PHONETIC(reference)PROPER
Text
Capitalize the first letter of each word-like segment in a text string.
Syntax
PROPER(text)REGEXEXTRACT
Text
Extract matching text or captured groups from a string using a regular expression.
Syntax
REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])REGEXREPLACE
Text
Replace matching text in a string by using a regular expression pattern.
Syntax
REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])REGEXTEST
Text
Check whether text matches a regular expression and return TRUE or FALSE.
Syntax
REGEXTEST(text, pattern, [case_sensitivity])REPLACE
Text
Replace part of a text string by character position and length.
Syntax
REPLACE(old_text, start_num, num_chars, new_text)REPT
Text
Repeat a text string a specified number of times.
Syntax
REPT(text, number_times)RIGHT
Text
Return characters from the right end of a text string.
Syntax
RIGHT(text, [num_chars])SEARCH
Text
Return the starting position of one text string inside another, without case-sensitive matching.
Syntax
SEARCH(find_text, within_text, [start_num])SUBSTITUTE
Text
Replace specific text inside a string by matching old text instead of character positions.
Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])T
Text
Return text values as text and convert non-text values to an empty string.
Syntax
T(value)TEXT
Text
Convert a value to text using a custom number, date, or time format.
Syntax
TEXT(value, format_text)TEXTAFTER
Text
Return the text that appears after a chosen delimiter.
Syntax
TEXTAFTER(text,delimiter,[instance_num],[match_mode],[match_end],[if_not_found])TEXTBEFORE
Text
Return the text that appears before a chosen delimiter.
Syntax
TEXTBEFORE(text,delimiter,[instance_num],[match_mode],[match_end],[if_not_found])TEXTJOIN
Text
Join text from multiple cells or ranges into one string with a delimiter you choose.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)TEXTSPLIT
Text
Split text into columns, rows, or both by using one or more delimiters.
Syntax
TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty],[match_mode],[pad_with])TRANSLATE
Text
Translate text into a chosen language using Microsoft Translation Services.
Syntax
TRANSLATE(text, [source_language], [target_language])TRIM
Text
Remove extra spaces from text while leaving single spaces between words.
Syntax
TRIM(text)UNICHAR
Text
Return a Unicode character from its numeric code, including symbols and nonbreaking spaces.
Syntax
UNICHAR(number)UNICODE
Text
Return the Unicode code point of the first character in a text value.
Syntax
UNICODE(text)UPPER
Text
Convert all letters in a text string to uppercase.
Syntax
UPPER(text)VALUE
Text
Convert a text representation of a number, date, or time into a numeric Excel value.
Syntax
VALUE(text)VALUETOTEXT
Text
Convert a value to concise text or a strict text representation with explicit quotation marks.
Syntax
VALUETOTEXT(value, [format])