The Excel TEXT functions are used to return information about a text string, to convert between text and other data types, and to split and concatenate text strings.

Function Description
CHARConvert CharactersReturns the character specified by the code number
CLEANRemove CharactersRemoves all nonprintable characters from text
CODEConvert CharactersReturns a numeric code for the first character in a text string
CONCATENATESelect/Combine TextJoins several text items into one text item
DOLLARConvert Data TypesConverts a number to text, using the $ (dollar) currency format
EXACTInformationChecks to see if two text values are identical
FIND, FINDBInformationFinds one text value within another (case-sensitive)
FIXEDConvert Data TypesFormats a number as text with a fixed number of decimals
LEFT, LEFTBSelect/Combine TextReturns the leftmost characters from a text value
LEN, LENBInformationReturns the number of characters in a text string
LOWERConvert Text CaseConverts text to lowercase
MID, MIDBSelect/Combine TextReturns a specific number of characters from a text string starting at the position you specify
NUMBERVALUEConvert Data TypesConverts text to number in a locale-independent manner (New in Excel 2013)
PROPERConvert Text CaseCapitalizes the first letter in each word of a text value
REPLACE, REPLACEBReplace TextReplaces characters within text
REPTSelect/Combine TextRepeats text a given number of times
RIGHT, RIGHTBSelect/Combine TextReturns the rightmost characters from a text value
SEARCH, SEARCHBInformationFinds one text value within another (not case-sensitive)
SUBSTITUTEReplace TextSubstitutes new text for old text in a text string
TInformationConverts its arguments to text
TEXTConvert Data TypesFormats a number and converts it to text
TRIMRemove CharactersRemoves spaces from text
UNICHARConvert CharactersReturns the Unicode character that is references by the given numeric value (New in Excel 2013)
UNICODEConvert CharactersReturns the number (code point) that corresponds to the first character of the text (New in Excel 2013)
UPPERConvert Text CaseConverts text to uppercase
VALUEConvert Data TypesConverts a text argument to a number