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.