content_image/732167.jpg content_image/732168.jpg content_image/732169.jpg
## SECTION V: Separating Text within a Cell 

When data is combined within a cell, such as a first and last name, Excel is able to separate this data into two cells. 

To separate data within a cell: 

1. Insert a blank column to the right of the column containing the merged data. 

2. Highlight the column of full names. 

3. Select the Data  tab. 

4. Select Text to Columns . 

The Convert Text to Columns Wizard dialogue box will. 

5. Choose the appropriate data type. 

To separate a column based on punctuation characters, select Delimited . 

<img src='content_image/732167.jpg'>

To separate a column based on spaces between each field, select Fixed Width . 

For this example we will select Delimited . 

<img src='content_image/732168.jpg'>

6. Select Next . 

7. Choose your delimiters for the text separation. 

For this example select Space . 

<img src='content_image/732169.jpg'>

8. Select Next . 

9. Select the data format for each column. 

For this example select General . 

