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.
33 functions
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], ...)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)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)REGEXREPLACE
Text
Replace matching text in a string by using a regular expression pattern.
Syntax
REGEXREPLACE(text, pattern, replacement, [occurrence], [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])TRIM
Text
Remove extra spaces from text while leaving single spaces between words.
Syntax
TRIM(text)TYPE
Text
Return a code that identifies the data type of a value.
Syntax
TYPE(value)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)