Hi,

I'm working with Excel 2003. I have a column that contains First Name,
space, Last name. I need it to contain Last Name, comma, space, First name.
I've searched through the other questions/answers and tried a few things
myself (like Text to columns) with no luck.

Is there anyway this can be done other than retyping?? I can create a new
column to hold the data and then delete the old one if necessary, I just need
to fix about 1100 rows and then from there I will enter it the correct way in
the first place.

Thanks in advance for any help.