HomeMicrosoft OfficeExcelConvert Text to Columns Wizard in Excel

Convert Text to Columns Wizard in Excel

In this post, you’ll learn how to convert text to columns using the “Convert Text to Column Wizard” in Excel.

When you wanna split texts into a column in Excel, you can do that in simple steps in Excel.

Text to Column in Excel

  • Firstly select the range of cells.
  • Go to the Data tab, under the Data tools group select the Texts to column option.
'Convert Text to Columns Wizard' in Excel
  • The Convert text to column wizard dialog box opens up, choose Delimited and click on Next.
'Convert Text to Columns Wizard' in Excel
  • In the Delimiters category, select the options that you’ve used as separators between two texts. And view the Data preview of your texts into columns.
  • Click on Finish.
  • This will result in conversion of texts into columns in Excel.
'Convert Text to Columns Wizard' in Excel

Share:

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021