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:  The Convert Text to Columns Wizard dialogue box will. To separate a column based on punctuation characters, select  Delimited . To separate a column based on spaces between each field, select  Fixed Width . For this example we will select  Delimited .  For this example select  Space .  27  8. Select  Next . 9. Select the data format for each column. 6. Select  Next .  7. Choose your delimiters for the text separation.  5. Choose the appropriate data type. 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 . For this example select  General . 