Perfect. You just saved me countless hours!
Thanks so much !

"Bob Phillips" wrote:

Use Data Text To Columns with comma as the delimiter.

--
__________________________________
HTH

Bob

"Betsy" wrote in message
...
I'd like to create (or use someone else's) a macro to edit names in Excel
spreadsheets. I need a.) to remove the last name and comma from a
last-name-first listing, and b.) to remove the comma and first name from a
last-name-first listing. In a.) that would leave the cell with only the
first
name remaining, and in b.) would leave only the last name remaining.

Anyone have any suggestions or available macro's?
thanks!
Betsy