TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

Read up for news, tips and tricks about budgeting, planning and forecasting.

Excel Tips

A guide to isolate data within text string in excel

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.

Extract Number from String Excel

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

 

extract number from string cell

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

extract number from string cell