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:
- Select the column that holds the text you want to convert into multiple columns.
- On the DATA tab, in the Data Tools group, click the Text to Columns command:
- 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:
- 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:
- 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:
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.
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:
- From the FILE menu tab, select Options.
- In the Excel Options dialog box, select Formulas on the left.
- Set options under Calculation options and click OK to save the changes.