Tip Printed from ExcelTip.com

---

Extracting Characters from Text Using Text Formulas


To extract characters from text, use Text category formulas:

Left:
Returns the first character(s) in a text string, based on the number of characters specified.

Mid:
Returns a specific number of character(s) from a text string, starting at the position specified based on the number of characters specified.

Right:
Returns the last character(s) in a text string, based on the number of characters specified.

Len:
Returns the number of characters in a text string.