Excel Text Functions

This page lists all of the built-in Excel Text Functions. These functions are provided by Excel, to help you to work with text strings.

They include functions to return information about a text string, to convert between text and other data types, and to split and concatenate text strings.

The functions have been grouped into categories, to help you to find the function you need. Each function link takes you to a full description of the function, with examples of use and common errors.


Excel Text Functions List

Functions to Remove Extra Characters
CLEANRemoves all non-printable characters from a supplied text string
TRIMRemoves duplicate spaces, and spaces at the start and end of a text string
Functions to Convert Excel Data Types
BAHTTEXTConverts a number, plus the suffix "Baht" into Thai text
DOLLARConverts a supplied number into text, using a currency format
FIXEDRounds a supplied number to a specified number of decimal places, and then converts this into text
TEXTConverts a supplied value into text, using a user-specified format
VALUEConverts a text string into a numeric value
NUMBERVALUEConverts text to a number, in a locale-independent way (New in Excel 2013)
Functions to Convert Between Upper & Lower Case
LOWERConverts all characters in a supplied text string to lower case
PROPERConverts all characters in a supplied text string to proper case (i.e. letters that do not follow another letter are upper case and all other characters are lower case)
UPPERConverts all characters in a supplied text string to upper case
Replacing / Substituting Parts of a Text String
REPLACEReplaces all or part of a text string with another string (from a user supplied position)
SUBSTITUTESubstitutes all occurrences of a search text string, within an original text string, with the supplied replacement text
Cutting Up & Piecing Together Text Strings
CONCATENATEJoins together two or more text strings
LEFTReturns a specified number of characters from the start of a supplied text string
MIDReturns a specified number of characters from the middle of a supplied text string
RIGHTReturns a specified number of characters from the end of a supplied text string
REPTReturns a string consisting of a supplied text string, repeated a specified number of times
Information Functions
LENReturns the length of a supplied text string
FINDReturns the position of a supplied character or text string from within a supplied text string (case-sensitive)
SEARCHReturns the position of a supplied character or text string from within a supplied text string (non-case-sensitive)
EXACTTests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive)
TTests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string.
Converting Between Characters & Numeric Codes
CHARReturns the character that corresponds to a supplied numeric value
CODEReturns the numeric code for the first character of a supplied string
UNICHARReturns the Unicode character that is referenced by the given numeric value (New in Excel 2013)
UNICODEReturns the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013)