Excel Text Functions List


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
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
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
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.


Popular posts from this blog

Comments