We’re getting back to basics with Excel- the tool we all love and hate.

1)  Locate the data that you want to isolate in your Excel string.

2)  On another column insert the Excel text function =mid(Cell #, Start #, Length of Sequence)

• Cell #: Refers to the cell of the data you are dealing with
• Start #: Refers to the number of the first character in the string that you want to isolate.
• Length of Sequence: Refers to how many characters do you want to isolate

3)  Once your formula has been inputted, extend the series by clicking the square at the bottom right of the cell.