How to: Split a single column of text into multiple columns in Excel 

You can split text into columns which is separated by the following delimiters:
Tab
Space
Comma
Semicolon
Other - if you have a custome character or symbol that is used to separate words, you can specify it here and it will act as a delimiter.
Steps:
1) copy the text into an excel worksheet;
2) select the full column
3) go to data, and press on the "Text to columns button"
4) select Delimited;
5) select which delimiter you want to use - should be based on the separator of your text;
6) press next;
7) press finish.
Created with the RU-vid Video Editor - all right reserved.