Back to function library

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 guides

41 functions

ARRAYTOTEXT

Text

2026-11-11

Convert an array to readable text or a strict representation that records its rows and columns.

Syntax

ARRAYTOTEXT(array, [format])
Used in 0 articlesView reference

ASC

Text

2026-06-13

Convert full-width DBCS characters to half-width single-byte characters.

Syntax

ASC(text)
Used in 0 articlesView reference

BAHTTEXT

Text

2026-06-13

Convert a number to Thai text and append the Baht currency suffix.

Syntax

BAHTTEXT(number)
Used in 1 articleView reference

CHAR

Text

2026-06-13

Return the character represented by a numeric character code.

Syntax

CHAR(number)
Used in 3 articlesView reference

CLEAN

Text

2026-06-13

Remove nonprintable characters from imported or copied text.

Syntax

CLEAN(text)
Used in 2 articlesView reference

CODE

Text

2026-06-13

Return the numeric code for the first character in a text string.

Syntax

CODE(text)
Used in 1 articleView reference

CONCAT

Text

2026-03-18

Join text from multiple cells or ranges into one string without adding a delimiter.

Syntax

CONCAT(text1, [text2], ...)
Used in 1 articleView reference

CONCATENATE

Text

2026-03-18

Join multiple text values into a single text string.

Syntax

CONCATENATE(text1, [text2], ...)
Used in 4 articlesView reference

DETECTLANGUAGE

Text

2026-11-11

Identify the language of text and return its language code using Microsoft Translation Services.

Syntax

DETECTLANGUAGE(text)
Used in 1 articleView reference

DOLLAR

Text

2026-06-13

Convert a number to text in currency format with configurable rounding.

Syntax

DOLLAR(number, [decimals])
Used in 1 articleView reference

EXACT

Text

2026-06-08

Compare two text strings and return TRUE only when they match exactly.

Syntax

EXACT(text1, text2)
Used in 1 articleView reference

FIND

Text

2026-03-18

Return the starting position of one text string inside another, with case-sensitive matching.

Syntax

FIND(find_text, within_text, [start_num])
Used in 2 articlesView reference

FIXED

Text

2026-06-13

Round a number, format it as text, and optionally suppress thousands separators.

Syntax

FIXED(number, [decimals], [no_commas])
Used in 1 articleView reference

LEFT

Text

2026-03-18

Return the first character or characters from a text string.

Syntax

LEFT(text, [num_chars])
Used in 4 articlesView reference

LEN

Text

2026-03-18

Return the number of characters in a text string.

Syntax

LEN(text)
Used in 3 articlesView reference

LOWER

Text

2026-06-13

Convert all letters in a text string to lowercase.

Syntax

LOWER(text)
Used in 1 articleView reference

MID

Text

2026-03-18

Return characters from the middle of a text string based on a start position and length.

Syntax

MID(text, start_num, num_chars)
Used in 5 articlesView reference

NUMBERVALUE

Text

2026-11-11

Convert numeric text to a number using the decimal and grouping separators in the source.

Syntax

NUMBERVALUE(text, [decimal_separator], [group_separator])
Used in 1 articleView reference

PHONETIC

Text

2026-06-13

Extract the phonetic furigana characters from a text string or referenced cell.

Syntax

PHONETIC(reference)
Used in 0 articlesView reference

PROPER

Text

2026-06-13

Capitalize the first letter of each word-like segment in a text string.

Syntax

PROPER(text)
Used in 1 articleView reference

REGEXEXTRACT

Text

2026-11-11

Extract matching text or captured groups from a string using a regular expression.

Syntax

REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])
Used in 1 articleView reference

REGEXREPLACE

Text

2026-11-11

Replace matching text in a string by using a regular expression pattern.

Syntax

REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])
Used in 0 articlesView reference

REGEXTEST

Text

2026-11-11

Check whether text matches a regular expression and return TRUE or FALSE.

Syntax

REGEXTEST(text, pattern, [case_sensitivity])
Used in 1 articleView reference

REPLACE

Text

2026-06-13

Replace part of a text string by character position and length.

Syntax

REPLACE(old_text, start_num, num_chars, new_text)
Used in 0 articlesView reference

REPT

Text

2026-06-13

Repeat a text string a specified number of times.

Syntax

REPT(text, number_times)
Used in 0 articlesView reference

RIGHT

Text

2026-03-18

Return characters from the right end of a text string.

Syntax

RIGHT(text, [num_chars])
Used in 4 articlesView reference

SEARCH

Text

2026-03-18

Return the starting position of one text string inside another, without case-sensitive matching.

Syntax

SEARCH(find_text, within_text, [start_num])
Used in 3 articlesView reference

SUBSTITUTE

Text

2026-09-18

Replace specific text inside a string by matching old text instead of character positions.

Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])
Used in 2 articlesView reference

T

Text

2026-06-13

Return text values as text and convert non-text values to an empty string.

Syntax

T(value)
Used in 0 articlesView reference

TEXT

Text

2026-03-18

Convert a value to text using a custom number, date, or time format.

Syntax

TEXT(value, format_text)
Used in 11 articlesView reference

TEXTAFTER

Text

2026-06-13

Return the text that appears after a chosen delimiter.

Syntax

TEXTAFTER(text,delimiter,[instance_num],[match_mode],[match_end],[if_not_found])
Used in 1 articleView reference

TEXTBEFORE

Text

2026-06-13

Return the text that appears before a chosen delimiter.

Syntax

TEXTBEFORE(text,delimiter,[instance_num],[match_mode],[match_end],[if_not_found])
Used in 1 articleView reference

TEXTJOIN

Text

2026-03-18

Join text from multiple cells or ranges into one string with a delimiter you choose.

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Used in 1 articleView reference

TEXTSPLIT

Text

2026-06-13

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])
Used in 2 articlesView reference

TRANSLATE

Text

2026-11-11

Translate text into a chosen language using Microsoft Translation Services.

Syntax

TRANSLATE(text, [source_language], [target_language])
Used in 1 articleView reference

TRIM

Text

2026-03-18

Remove extra spaces from text while leaving single spaces between words.

Syntax

TRIM(text)
Used in 17 articlesView reference

UNICHAR

Text

2026-11-03

Return a Unicode character from its numeric code, including symbols and nonbreaking spaces.

Syntax

UNICHAR(number)
Used in 3 articlesView reference

UNICODE

Text

2026-11-11

Return the Unicode code point of the first character in a text value.

Syntax

UNICODE(text)
Used in 1 articleView reference

UPPER

Text

2026-06-13

Convert all letters in a text string to uppercase.

Syntax

UPPER(text)
Used in 1 articleView reference

VALUE

Text

2026-03-18

Convert a text representation of a number, date, or time into a numeric Excel value.

Syntax

VALUE(text)
Used in 5 articlesView reference

VALUETOTEXT

Text

2026-11-11

Convert a value to concise text or a strict text representation with explicit quotation marks.

Syntax

VALUETOTEXT(value, [format])
Used in 0 articlesView reference

Browse more function categories