Excel: Text to Columns

If you have data in a column that needs to be split up into multiple columns then you may want to consider using the text to columns feature. For example, if you have a list of names such as first name and last name in a single column you may want to split them into separate columns.

There is another way to do this which is useful is you want to keep the data in the original column, it is also a useful tutorial to understand using the different text functions in Excel. Click here for this tutorial