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.