splitting data in one column into two columns

Hi, new here so forgive me if I'm doing something wrong. Can anyone tell me if this is possible?
I have data in column A which is separated by a comma (lastname, firstname). I need to split it up into 2 columns without any commas
Column A (last name) and Column B (first name)
Can this be done easily. I have over 10,000 rows and only know to cut the first name out and paste into the new column. There's gotta be an easier way.

Thanks for any help,
Steven

Hi Steven,

You could either use Excel's Text to Columns option from the Data menu (Excel 2003), or use the following formulas (which are based on an assumption that the data starts at A2 - change as required):

First Name formula: =LEFT(A2,SEARCH(",",A2)-1)
Last Name formula: =MID(A2,SEARCH(",",A2)+1,LEN(A2)-SEARCH(",",A2))

HTH

Robert

Hi,
Thanks for your help. The text to columns tool work perfectly. I never knew how to use that feature. Now I do. Thanks!