Below listed are the various string / text functions of Microsoft Excel 2007.
ASC function changes the given double-byte characters to single-byte characters.
BAHTTEXT function converts the given numbers to baht text.
CHAR function is used to convert a number to ANSI character
CLEAN function is used to remove any non-printable characters from the given text.
CODE function is used to return the ANSI code of the given character.
CONCATENATE function is used to join two or more texts into a single text.
DOLLAR function is used to convert the given number to currency, formatted as text.
EXACT function is used to find if the given two texts are exactly the same.
FIND function is used to find the position of a specific letter in the text.
FIXED function is used to convert the given number to text.
LEFT function is used to return the specified number of characters from the left hand side of the content.
LEN function is used to find the number of characters in a given text.
LOWER function is used to convert the given text to the lower case.
MID function is used to pick characters from the middle of the given text.
PROPER function converts the first letter of all the given words to upper case and the other letters to lower case.
REPLACE function replaces a part of the text with a different text.
REPT function repeats the given text number of times mentioned in the function.
RIGHT function returns the specified number of characters from the right hand side of the text.
SUBSTITUTE function replaces a part of text with another text.
T function checks whether the given entry is text or not.
TRIM function removes all the extra spaces from the given text.
UPPER function converts the given text to the upper case.