Excel Spreadsheets Text Functions (24)
Importance
Functions
What it Does
Interesting
CONCATENATE
Joins several text items into one text item
Interesting
FIND
Finds one text value within another (case-sensitive)
Interesting
LEFT
Returns the leftmost characters from a text value
Interesting
LEN
Returns the number of characters in a text string
Interesting
MID
Returns a specific number of characters from a text string starting at the position you specify
Interesting
REPT
Repeats text a given number of times
Interesting
RIGHT
Returns the rightmost characters from a text value
Interesting
TEXT
Formats a number and converts it to text
Interesting
TRIM
Removes spaces from text
Interesting
VALUE
Converts a text argument to a number
Rarely Used
BAHTTEXT
Converts a number to text, using the ß (baht) currency format
Rarely Used
CHAR
Returns the character specified by the code number
Rarely Used
CLEAN
Removes all nonprintable characters from text
Rarely Used
CODE
Returns a numeric code for the first character in a text string
Rarely Used
DOLLAR
Converts a number to text, using the $ (dollar) currency format
Rarely Used
EXACT
Checks to see if two text values are identical
Rarely Used
FIXED
Formats a number as text with a fixed number of decimals
Rarely Used
LOWER
Converts text to lowercase
Rarely Used
PROPER
Capitalizes the first letter in each word of a text value
Rarely Used
REPLACE
Replaces characters within text
Rarely Used
SEARCH
Finds one text value within another (not case-sensitive)
Rarely Used
SUBSTITUTE
Substitutes new text for old text in a text string
Rarely Used
T
Converts its arguments to text
Rarely Used
UPPER
Converts text to uppercase