How to Convert Text to Columns

Home / How to Convert Text to Columns

How to Convert Text to Columns

April 11, 2019 | Excel | No Comments

There are lots of ways to remove space form excel. I’ll tell you three populist ways to remove space form excel
You want to place name and surname in different columns, then there is a way to excel too, first of all, we will know that the name and surname are different columns with any space
First, you open the excel sheet which gives space in the name an the surname as soon as the excel sheet is open where you have to paste name and surname please selected cells you have paste name and surname
After that go to the menu and select the data
After selecting menu data, then you select text to columns

Menu >> Data >> Text To Columns

Convert Text to Columns
Convert Text to Columns

After you have a pop up open which is called convert text to columns wizard
After you select the Delimited menu and click the next button
Then tick the space on right and press the next button and then click on the finish button

Click on Delimited >> Next >> Click on Space >> Next >> Finish


Convert Text to Columns
Convert Text to Columns
Convert Text to Columns
Convert Text to Columns

Then you can see that both the name and surname have come in different cells and the columns of both have been separated. in this way you can see that name and surname cells and columns are different.

Convert Text to Columns

About Author

Leave a Reply

Your email address will not be published. Required fields are marked *