Scanning Names and Pasting

Hey all,
I could not find a thread similar, so please let know if you can help...
I have a spread with first then last names (example 'Gary White' and sometimes 'White, Gary'). Is there a function I could write to take the first and last name and put them in two different additional colomns? I have over 700 so a function would be best instead of just typing away. Thank you!

Excel 2007

Data => text to collumn

use space as seperator.

Thank you! this worked beautifully! I now have another problem in the same spreadsheet though! I have data to enter (scores) for a lot of items.... I know how to enter the formula so it can grade each category (in %) based on the sum of the columns in that category divided by the total possible for those columns. But sometimes I need to enter N/A which may bring down the grade to a 83.33% when they should have a 100%...How do you make excel only count the column if a numerical value is placed???
THANK YOU ALL

=COUNT(A:A) when entered will count all numbers, however, say i put "see notes" in a column that COUNT will ....count.... then it returns #### in the sum column....

ACTUALLY IT DID HELP>>>. haha got it! thank you!