PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Table of Contents

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 in excel
GO TO DATA>DATA TOOLS

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.
text to column in excel

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

text to column for excel

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

After clicking next, the output appears.

text to column in excel
CLICK FINISH.
The output is shown below.
text to column

WHEN SEPARATOR IS “. OR , OR ANYTHING ELSE:

STEPS:

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

 

text to column in excel
CLICK FINISH.
The output is shown below.

OTHER WAYS TO REACH THIS ARTICLE

  • TEXT TO COLUMN CONVERSION, SEPARATE TEXT INTO COLUMNS, EXAMPLE TO SEPARATE COLUMNS, SEPARATE TEXT INTO COLUMNS

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW