Converting Text to Columns

Contact Us or call 1-877-932-8228
Converting Text to Columns

Converting Text to Columns

If you have a list of data in which all the information appears in one column, you can use the Text to Columns command to convert the data to multiple columns. This is generally much easier than retyping the data!

To convert text to columns in Microsoft Excel:

  1. Select the column that holds the text you want to convert into multiple columns.
  2. On the DATA tab, in the Data Tools group, click the Text to Columns command:Text to Columns
  3. In the Convert Text to Columns Wizard - Step 1 of 3 dialog box, select either Delimited (if your data is separated by commas, tabs, or spaces) or Fixed Width (if your data contains a certain number of characters in each field). You will almost always select Delimited in this step. Click Next:Delimited
  4. In the Convert Text to Columns Wizard - Step 2 of 3 dialog box, select the Delimiters (assuming you selected Delimited in the prior step). If you aren't sure what to select, you can select and deselect the options and see the results in the Data preview. After making your selection(s), click Next:Data Preview Results
  5. In the Convert Text to Columns Wizard - Step 3 of 3 dialog box, you can select the data format for each column or you can elect not to import a column. Simply select the column under Data preview and then select the Column data format above. In this step, you also specify where you want the data to show up. After you make your selections, click Finish:Finish

    Linking to External Data

    In Excel 2013, you can use the options in the Get External Data group of the DATA tab to link to data in different sources, such as text files, Microsoft Access, and the Internet.

    Get External Data Group

    Controlling Calculation Options

    In Excel, calculation refers to Excel's ability to automatically compute formulas and display the results. You can alter the calculation options.

    To control calculation options:

    1. From the FILE menu tab, select Options.
    2. In the Excel Options dialog box, select Formulas on the left. Formulas
    3. Set options under Calculation options and click OK to save the changes. Calculation Options
Next