I have a file that I receive daily in which Column A is in this format:

xxxxxxxx FirstName LastName

(xxxxxxxx is account number)

I need to build a macro to automatically convert all of column A into:

xxxxxxxx LastName, FirstName


Basically, it needs to swap the first and last name, and add the comma.

Can anyone help me out on this? I think I could figure out how to do it with the CONCATENATE operator, but I'm not sure how to split the first cell with a macro. Any help would be greatly appreciated. Thank You.