Dividing a Column in Excel

Have you ever gotten a spreadsheet from someone where the first and last names were in the same column and you needed them in separate columns?  This happened to me just this week, but there was an easy way to divide these without having to go to each cell and change it.  Here's how:

• Insert a blank column to the right of the one you are dividing (if there’s not already one there).
• Highlight the column where the names are in the spreadsheet.
• Select Data from the menu bar.
• Choose Text to Columns.
• Make sure Delimited is selected and click NEXT.
• If the names are entered with just a space between then check only SPACE; if they are separated by a comma and a space, then check both COMMA and SPACE.
• Click NEXT.
• Then FINISH.

If you have 3 names given on some (i.e. Joe Bob Smith) then you will have some cleaning up to do, but it's still a lot quicker than doing them all manually.