Convert separate text to column by space using function Text to column

Convert separate text to column

Introduction –

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.

Convert separate text to column by space using function Text to column

Steps –

Select the Data.follow the step.
Go to 
Data >> Text to column >> click on delimited >> Click Next

Convert separate text to column by space using function Text to column

We want text separate by space. 
Click to space radio button.
You can view data preview.
then click to Finish
Convert separate text to column by space using function Text to column

Your Selected Data shows is in different column.
Convert separate text to column by space using function Text to column

Leave a Comment