Picking up a few characters from cell:Excel

To pickup a certain few characters from a data entry in  a cell we have three different functions.

1. MID function : This function has three arguments to be entered. The cell from which the characters/string will be taken, the position of the string from where we want to start and the number of strings to be taken.

2. Left function: Only two arguments to be entered .The cell from which the characters/string will be taken and the number of characters be taken.

3. Right function: Starts from the right side. Syntax same as left.

Below is example of usage of all the three. with the functions and the results listed for each.