Convert separate text to column
For the Text convert in to the separate column function mostly use Text to column.
It is the very simple Function. Few steps are required.
In the given image Employee full name. We are separate first name & Last name in separate column.
Select the Data.follow the step.
Data >> Text to column >> click on delimited >> Click Next
We want text separate by space.
Click to space radio button.
You can view data preview.
then click to Finish
Your Selected Data shows is in different column.