|Text Formulas and Functions in Excel:
- LEN returns the number of characters in a text string.
FIND finds one text string (find_text) within another text string
(within_text), and returns the number of the starting position of
find_text, from the first character of within_text.
Text is the text string that contains the characters you want to
extract. Num_chars specifies the number of characters you want LEFT to
extract from the 'left'.
RIGHT returns the last character or characters in a text string, based on the number of characters you specify
MID returns a specific number of characters from a text string,
starting at the position you specify, based on the number of characters
a combination of the above formulas, particularly, 'left', 'right' and
'find', a number of interesting text manipulations can be done.