Excel® 2013 On Demand

Converting Text to Columns

The Convert to Columns Wizard helps you separate simple cell contents into different columns. For example, if a cell contains first and last names, you can use the Convert to Columns Wizard to separate first and last name into different columns. The wizard uses the delimiter—such as a tab, semicolon, comma, space, or custom—to determine where to separate the cell contents into different columns; the wizard options vary depending on the delimiter type. For example, the cell contents Julie, Kenney uses the comma delimiter.

Convert Text to Columns

Select the range you want to convert to columns.

Click the Data tab.