How To Use Text To Column

For converting text  data into excel separate columns we use this function.Text data is seaprated by some seaprator ~, slash or anything.Thus to make it row and columns in excel we use this function.

Steps to use Text to column function in excel:

1 If data is separated by slash( / ) or any other separator if we want to convert it to column. Then we use text to column for it

Amritsar/Sonipat/Hisar

2 Select Data From Data Bar-> Select Text to column

2 There Are Two Option Delimit and Fixed Width. Use Delimit to separate by slash or any tab. Use Fixed Width if separated by space

In Window appeared select Other and Enter Slash(/) and Press Next

3 Select Finish

4 Data is separated column vise as shown below

This is How we can convert text data to excel by using this function.