Switch Last Name With First Name in a Cell

[brent_milne]

In Column B I have a list of names separated by a comma in the following format: Doe, John. I need to have the format: John, Doe or preferably John Doe. I could also move the last name to Column C if that would be easier. (ie. B1=John C1=Doe). I was hoping someone could give a start for a macro if this is even possible. I have tried a couple of examples from other places but they weren't what I needed. Thanks for any help.

[extremis]

Please Login or Register  to view this content.

[xladept]

Hi Brent,

Here's a function:

Please Login or Register  to view this content.

Put it in a module and then you can use it in the worksheet or in code:

Please Login or Register  to view this content.

[jolivanes]

@brent_milne
Please read the forum rules about cross posting.