Split Cell Data to Columns

In this tutorial, I will be walking through another fantastic facility provided by MS Excel. You may have encountered the of copying the tabular data from web or a word document but the data, for some reason, instead of forming a table on excel sheet is copied to a single cell table. Below is an example of a similar situation

As you can see that Name, Surname and Address are in the same cell. It may be a tedious task to format the data manually or in certain cases impossible when the data is huge. So here comes a facility provided by MS Excel , Text to Columns, to your rescue. It can be locate in the 'Data' tab

If you select the data and click on 'Text to Columns', you will see a window like the one below

It may remind you of tutorials of importing text data from a file (Fixed Length and Delimited). If you are already aware of these, then rest of the process will seem same to you and it is. However, if you are not familiar with these, carry on.

Keep the default option of 'Delimited' as it is and click on 'Next'. You will be taken to a screen like the one below

Choose appropriate delimiters on this screen so that your data can be divided into columns. For the purpose of this example, I selected 'Comma' and 'Space' along with 'Tab' which was already there. As you can see, the target division is already shown for the data rows. You can review this split at this point and can define your own delimiter to serve your purpose if you wish using 'Other' option. 

After you are satisfied with the division, click on 'Next' which will take you to the below screen

You can pick your destination cells on this screen as well as define columns data types here. Once you are happy with your changes, click on 'Finish to complete the task. You will see the below results 

You can now see, how simple it was to split your cell data to multiple columns. Please leave you feedback here so that I can improve upon my tutorials.