EXCEL - Want to split cell value where comma occurs 1

[sophy]

Hi all --

I have an Excel spreadsheet which has a field called "names" which has lastname, firstname in it. I'd like to separate out the last name into a cell and the firstname into a separate cell. They are separated by a comma. I can't for the life of me figure out the command for this. Any help would be gratefully received!

Many thanks,
Sophy

 

[SkipVought]

Sophy,

Use Data/Text to columns... wizard.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[sophy]

Hi Skip --

Most excellent! It worked. Thanks!

Cheers, Sophy