HOW TO CONVERT TEXT TO COLUMN IN EXCEL?

INTRODUCTION

TEXT TO COLUMN is  a good feature in Excel which facilitates us to convert the text to columns or simply saying to segregate the text to different columns or separate the cell content into different columns.

BUTTON LOCATION TO CONVERT TEXT TO COLUMN IN EXCEL

TEXT TO COLUMN BUTTON LOCATION

STEPS TO CREATE TEXT TO COLUMN IN EXCEL

TEXT to COLUMNS:

Its a good feature in Excel which facilitates us to convert the text to columns or simply saying to segregate the text to different columns or separate the cell content into different columns.

EXAMPLE

Suppose we have a cell containing the text

WELCOME TO GYANKOSH (SEPARATOR IS “SPACE”)

TARGET is to segregate the above phrase into three columns.

STEPS:

  • Select the cell containing the text. (A full column can be there but for our example, we are taking a cell only).
  • Click TEXT TO COLUMN button. A dialog box will open.
CHOOSE FIXED WIDTH AND CLICK NEXT

After clicking NEXT, next screen will appear, which is self explanatory.

CLICK NEXT

​We are going to split the text into three columns. Click NEXT.

After clicking next, the output appears.

CHECK THE OUTPUT FORMAT IN THE BOTTOM AND CLICK FINISH

CLICK FINISH.The output is shown below.

OUTPUT [ THE TEXT IS SPLIT IN COLUMNS ]

WHEN SEPARATOR IS ” , . OR , OR ANYTHING ELSE:

STEPS:

  • SELECT THE CELL.
  • CLICK TEXT TO COLUMN BUTTON
  • CHOOSE DELIMITED OPTION as already described.
CHOOSE THE APPROPRIATE SEPARATOR AND CLICK NEXT
  • CLICK NEXT.
  • NEXT OPTION IS ALREADY DISCUSSED. THE OUTPUT WILL BE AS DESIRED.
CHECK THE FINAL OUTPUT AND CLICK FINISH

CLICK FINISH.The output is shown below.

FINAL OUTPUT