Excel Text Formulas
Functions for manipulating and analyzing text strings: extraction, concatenation, formatting, and searching.
49 formulas
16 Beginner
21 Intermediate
12 Advanced
CONCAT
Beginner
=CONCAT(text1, [text2], ...)TEXTJOIN
Intermediate
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)LEFT
Beginner
=LEFT(text, [num_chars])RIGHT
Beginner
=RIGHT(text, [num_chars])MID
Beginner
=MID(text, start_num, num_chars)LEN
Beginner
=LEN(text)FIND
Intermediate
=FIND(find_text, within_text, [start_num])SEARCH
Intermediate
=SEARCH(find_text, within_text, [start_num])SUBSTITUTE
Intermediate
=SUBSTITUTE(text, old_text, new_text, [instance_num])REPLACE
Intermediate
=REPLACE(old_text, start_num, num_chars, new_text)TRIM
Beginner
=TRIM(text)CLEAN
Beginner
=CLEAN(text)UPPER
Beginner
=UPPER(text)LOWER
Beginner
=LOWER(text)PROPER
Beginner
=PROPER(text)TEXT
Intermediate
=TEXT(value, format_text)VALUE
Beginner
=VALUE(text)NUMBERVALUE
Intermediate
=NUMBERVALUE(text, [decimal_separator], [group_separator])CHAR
Intermediate
=CHAR(number)CODE
Intermediate
=CODE(text)UNICHAR
Intermediate
=UNICHAR(number)UNICODE
Intermediate
=UNICODE(text)EXACT
Beginner
=EXACT(text1, text2)REPT
Beginner
=REPT(text, number_times)DOLLAR
Beginner
=DOLLAR(number, [decimals])FIXED
Beginner
=FIXED(number, [decimals], [no_commas])T
Beginner
=T(value)TEXTSPLIT
Intermediate
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])TEXTBEFORE
Intermediate
=TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])TEXTAFTER
Intermediate
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])VALUETOTEXT
Intermediate
=VALUETOTEXT(value, [format])ARRAYTOTEXT
Intermediate
=ARRAYTOTEXT(array, [format])REGEXEXTRACT
Advanced
=REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])REGEXREPLACE
Advanced
=REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])REGEXTEST
Advanced
=REGEXTEST(text, pattern, [case_sensitivity])DETECTLANGUAGE
Intermediate
=DETECTLANGUAGE(text)TRANSLATE
Intermediate
=TRANSLATE(text, [source_language], [target_language])ASC
Intermediate
=ASC(text)DBCS
Intermediate
=DBCS(text)BAHTTEXT
Intermediate
=BAHTTEXT(number)PHONETIC
Advanced
=PHONETIC(reference)FINDB
Advanced
=FINDB(find_text, within_text, [start_num])LEFTB
Advanced
=LEFTB(text, [num_bytes])LENB
Advanced
=LENB(text)MIDB
Advanced
=MIDB(text, start_num, num_bytes)REPLACEB
Advanced
=REPLACEB(old_text, start_num, num_bytes, new_text)RIGHTB
Advanced
=RIGHTB(text, [num_bytes])SEARCHB
Advanced
=SEARCHB(find_text, within_text, [start_num])JIS
Advanced
=JIS(text)