ARRAYTOTEXT
Returns an array of text values from any specified range.
TextModern Excel FunctionsText Processing
Text
Text functions are essential for cleaning and transforming imported or inconsistent data.
They help standardize text before analysis and reporting.
Text functions are frequently used in data preparation workflows.
Tips
- Clean text data before analysis.
- Combine multiple text functions for best results.
Excel functions in this category (44)
ASC
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters.
TextText Processing
BAHTTEXT
Converts a number to text, using the ß (baht) currency format.
TextText Processing
CHAR
Returns the character specified by the code number.
TextText Processing
CLEAN
Removes all nonprintable characters from text.
TextBeginner EssentialsMost UsedText Cleaning
CODE
Returns a numeric code for the first character in a text string.
TextText Processing
CONCAT
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
TextModern Excel FunctionsMost UsedText Processing
CONCATENATE
Joins several text items into one text item.
TextMost UsedText Processing
COPILOT
Categorize, summarize, and generate text using Copilot.
TextText Processing
DBCS
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
TextText Processing
DETECTLANGUAGE
Identifies the language of a specified text.
TextModern Excel FunctionsText Processing
DOLLAR
Converts a number to text, using the $ (dollar) currency format.
TextText Processing
EXACT
Checks to see if two text values are identical.
TextText Processing
FIND
Finds one text value within another (case-sensitive).
TextText Processing
FIXED
Formats a number as text with a fixed number of decimals.
TextText Processing
JIS
Changes half-width (single-byte) characters within a string to full-width (double-byte) characters.
TextText Processing
LEFT
Returns the leftmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
LEN
Returns the number of characters in a text string.
TextBeginner EssentialsMost UsedText Processing
LOWER
Converts text to lowercase.
TextText Processing
MID
Returns a specific number of characters from a text string starting at the position you specify.
TextBeginner EssentialsMost UsedText Processing
NUMBERVALUE
Converts text to number in a locale-independent manner.
TextText CleaningText Processing
PHONETIC
Extracts the phonetic (furigana) characters from a text string.
TextText Processing
PROPER
Capitalizes the first letter in each word of a text value.
TextText Processing
REGEXEXTRACT
Extracts strings within the provided text that matches the pattern.
TextModern Excel FunctionsText Processing
REGEXREPLACE
Replaces strings within the provided text that matches the pattern with replacement.
TextModern Excel FunctionsText Processing
REGEXTEST
Determines whether any part of text matches the pattern.
TextModern Excel FunctionsText Processing
REPLACE
Replaces characters within text.
TextText CleaningText Processing
REPT
Repeats text a given number of times.
TextText CleaningText Processing
RIGHT
Returns the rightmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
SEARCH
Finds one text value within another (not case-sensitive).
TextText Processing
SUBSTITUTE
Substitutes new text for old text in a text string.
TextMost UsedText CleaningText Processing
T
Converts its arguments to text.
TextText Processing
TEXT
Formats a number and converts it to text.
TextText CleaningText Processing
TEXTAFTER
Returns text that occurs after given character or string.
TextModern Excel FunctionsText CleaningText Processing
TEXTBEFORE
Returns text that occurs before a given character or string.
TextModern Excel FunctionsText CleaningText Processing
TEXTJOIN
Combines the text from multiple ranges and/or strings.
TextModern Excel FunctionsMost UsedText Cleaning
TEXTSPLIT
Splits text strings by using column and row delimiters.
TextModern Excel FunctionsText CleaningText Processing
TRANSLATE
Translates a text from one language to another.
TextModern Excel FunctionsText Processing
TRIM
Removes spaces from text.
TextBeginner EssentialsMost UsedText Cleaning
UNICHAR
Returns the Unicode character that is references by the given numeric value.
TextText Processing
UNICODE
Returns the number (code point) that corresponds to the first character of the text.
TextText Processing
UPPER
Converts text to uppercase.
TextText Processing
VALUE
Converts a text argument to a number.
TextText CleaningText Processing
VALUETOTEXT
Returns text from any specified value.
TextModern Excel FunctionsText Processing