Thursday, February 13, 2014

Convert Text to Columns - Separating Last, First Names

Have you ever had a set of data that you wanted to separate across multiple columns?  "Text to Columns" is just for you!

Here is our Data Set:

The Request: "Please separate the client names into separate last name and first name columns"

This is SUPER EASY, so here we go...

1. Highlight the data you wish to separate

2. On the Ribbon, go to "Data" > "Text to Columns" in the "Data Tools" category

3. You should see this:

4. Since our data is separated by commas, we will select "Delimited" and click "Next"

5. Place a check in the "Comma" Checkbox and deselect the others

6. Look at the Data Preview to see what the output will look like prior to proceding:

7. Click "Next"

8. This screen will allow you to format the text by column.  For this demonstration, we're happy with a               "General" format (the default).

9. In the Destination box, enter the location where you wish the first data point to appear.  In this case, let's select "$B$16" - just to the right of the names that we are using for this example. 

10. Click "Finish".

You should now see:


No comments:

Post a Comment