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

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: