MS EXCEL TEXT FUNCTIONS

BHATTEXT
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT returns the specified number of characters from the end of the text string.
SEARCH returns the number of the character at which a specific character or text is first found, reading left to right(not case-sensitive).
SUBSTITUTE replaces existing text with new text in a text string.
T checks whether a value is text, and returns the text if it is, or returns double quotes(empty text) if it is not.
TEXT converts a value to text in a specific number format
TRIM removes all spaces from a text string except for single spaces between words.
UPPER converts a text string to all uppercase letters
VALUE converts a text string that represents a number to a number