Formulas: String Functions

STRING FUNCTIONS:

To remove all non printable characters.	CLEAN	=CLEAN(text)
To combine two or more strings.	CONCATENATE	=CONCATENATE(text1, text2)
		to combine any specific word use "" (inverted commas) like "excel".
To extract a substring from a string starting from the left-most character.	LEFT	=LEFT(text, no of characters)
To find the length of any specified string.	LEN	=LEN(text)
To convert all the letters in lowercase.	LOWER	=LOWER(text)
To convert all the letters in uppercase.	UPPER	=UPPER(text)
To set the first character in each word to Uppercase	PROPER	=PROPER(text)
To remove all leading and trailing spaces.	TRIM	=Trim(text)
To extract a substring from a string between two specific numbers.	MID	=MID(text, start_position, number_of_characters)
To replace a set of characters with another from a string.	SUBSTITUTE	=SUBSTITUTE(text, old_text, new_text, [starting position])