How to split data into multiple columns
Now we will see that we can split our existing data into multiple columns according to our requirement in MS Excel.
For example we have and column of employee name in which it is with first name and last name both together. But now we want to separate first name and last name into two different columns then we will first insert two column next to employee name column, then we will select that employee name column and then from our DATA tab we will select text to column option.
Inside that we will need to choose the option that how we want to separate our field, separate it with the help of commas or space, or some other fixed process. Then next we will select our separator that is space, and provide with the destination.
This well separate the first name and last name of our employees in two different columns.
Share a personalized message with your friends.