Getting Alphabetic info out of a cell

[Robcpa]

I have a datebase of clients, last name first separated by a comma and then the first name. I want to have a macro that will go into the cell and put the first name in one cell and the last name in another cell. Can this be done and how? Any help will be appreciated.
Rob

[NBVC]

You may not need a macro.

Try selecting the column and go to Data|Text to Columns
Select Delimited
Click Next
Select Comma
Click Finish