Hey guys,

I'm sorry if this has been answered before, but I wasn't able to find any that worked for this situation.

I have about 4,000 names in column A that are currently in the format LastName, FirstName XX (XX stands in place of a two-character job title abbreviation, and as such is different from row to row; not how I would have done this, but it is what it is).

I need to figure out a way to change these cells to FirstName LastName XX. It makes no difference to me if this is accomplished by initially splitting the data into individual columns and then reassembling, or if it's all done with a single command.

To further complicate matters, there are more than a few entries in here with multiple first names (i.e., Smith, Mary Beth NP).

I've found formulas in the forums that have gotten me fairly consistently to FirstName XX LastName, but can't get over the hump to the fully correct format.

Any help you guys can offer would be greatly appreciated. I've been given a friendly challenge that I'll be unable to sort this out before the morning, and I'd really love to have it corrected and in their inbox by morning.

Thanks again, everyone.

Mike