moving the 2nd word in a cell in front of the first word

Hello.

I tried to search but it's been difficult

I have a huge list of names, but I need to fix the formatting. Currently it's First Name space Last name , ie. Bob Smith , and i need this list to be Last name comma first name .. Smith, Bob

How do I make a macro that finds the 2nd word in a cell, moves that word in front of the first word then adds a comma+space so that it reads correctly?

Thanks for all your help

-Jeff
California

You can do this without code, e.g.:

Please Login or Register  to view this content.

Back up first and try

Please Login or Register  to view this content.