I need a simple macro built. I have an excel spreadsheet full of names. for example: Smith, John Ray Jr.
I need the macro to go down the list and convert it to two separate fields "first name" "last name" and eliminate everything else ( I don't need Ray Jr. etc.)
49 freelance font une offre moyenne de $22 pour ce travail
Hello, Please confirm first name will be first word after comma and last name will be first word before comma. Please send sample data. Looking forward to your reply. Regards, Aditya