Splitting Delimited Data to Columns

 Have you ever have data separated by some delimiters like comma, semicolon, full-stop ?

To split this data in a single column to different columns, we can use Excel.

Lets check this..

I have data like this "A,B,C,D,E,F,G,H" in a single column

To split this into multiple rows, Select data then go to "Data" tab and select "Text to Columns"

Next select "Delimited" in following pop out

Click Next, select required delimiter

Click Next, select Finish

Done, we can see that our data got split to multiple rows