Splitting Text Into Separate Columns

Thursday, December 13th, 2012

Written by Jane Hames

Lists of data are often received in a format that is not ideal for the work that needs to be carried out with it. One example of this is when you have first name and surname in one cell, where you really need the information to be in two separate cells.

A quick and easy (when you know how) solution is the Text to Columns feature and the following tutorial describes how to do it.

Read more on Splitting Text Into Separate Columns…