The LEN, LEFT, RIGHT and MID Functions

The LEN(fexf) function returns the number of characters in a text string. 

The LEFT(fexf, num characters) function returns the leftmost character or characters in a text string. For example, LEFT( 02167-3860 ,5) returns 02167. If num characters is omitted, the value 1 is assumed. The RIGHT(fexf, num characters) function is similar. If cell B7 contains a nine-digit number, then RIGHT(B7,4) returns the last four digits of the number. 

The syntax of the MID function is MID(fexf, start num, num characters) it returns a specific number of characters from a specified position in a text string. For example, if cell A1 contains H2S04, the expression MID(A1,3,1) returns S. 

---