Question

What is Convert Text to Columns? Write down the steps to convert Text to columns.

Answer 1

In order to separate the contents on one excel cell into separate columns, one can use the convert text to columns on the data tab in the data tools.

You need to highlight the range of the cells having text to be separated and then go to data text to columns select fixed width and follow the process.

Answer 2

Answer:

some times , we need to separate the content of one excel sell into separates column for this we can use a convert taxed to colums wizard for example : when we want to separate the a list full names into last and first name.

the steps to convert taxed to colums are as follows. so there are six steps

1 type the data in a worksheet

2 select the range with full

3 on the data tab click taxed to colums

4 choose the limited an click next

5 clear all the check boxes under delimiters except for the comma and space check boxes

6 click finish