Convert text to columns

Save time, let Leo do it for you!

Leo helps organizations by providing unparalleled and innovative help and support on Microsoft Office 2007 and 2010 applications.

Get Leo for your organization to:

  • Reduce deployment, adaptation time and training costs for new software
  • Decrease dependence on your help desk
  • Minimize loss of productivity


Separate a cell that contains multiple values into different columns according to a delimiter (such as a space or comma) or a column break location in your data.

Topic: Office 2007 /Excel /Data

Convert text to columns Microsoft Excel 2007  1
  • Select a cell or column of cells containing the content you want to split.
  • Click
Convert text to columns Microsoft Excel 2007  2
  • Click
Convert text to columns Microsoft Excel 2007  3
  • Select whether to use delimiters or fixed width to split the data. Note: Delimited data is separated by characters such as a space or comma. Fixed width data is separated by column breaks that you define.
  • Click
Convert text to columns Microsoft Excel 2007  4
  • Click
Convert text to columns Microsoft Excel 2007  5
  • Select the check boxes of the delimiters to separate columns of cells. Select the Treat consecutive delimiters as one check box if your data contains delimiters that appear consecutively. Select a Text qualifier to ignore certain delimiters.
  • Click
Convert text to columns Microsoft Excel 2007  6
  • Select the cells to contain the split data.
  • To format the data in the new columns, click the data header in the Data preview section, and then select a destination data format.
  • Click
Convert text to columns Microsoft Excel 2007  7
  • Click
Convert text to columns Microsoft Excel 2007  8
  • Click
Convert text to columns Microsoft Excel 2007  9
  • Follow the instructions to split your data accordingly.
  • Click
Convert text to columns Microsoft Excel 2007  10
  • Select the cells to contain the split data.
  • To format the data in the new columns, click the data header in the Data preview section, and then select a destination data format.
  • Click

Tags: ,