I want VBA code to convert names into first name and last name with same format please must use ranges so that i could edit them.
example is also in attached file.
I want VBA code to convert names into first name and last name with same format please must use ranges so that i could edit them.
example is also in attached file.
Hello,
Attached is your test file
Thanks Carim.
You are welcome
Just noticed you needed a VBA solution ...
Attached is the macro
Thanks for your Thanks ... AND for the Like
Sorry ... not sure to understand ...
Do you mean the Source Column C should be replaced by the two New Columns J and K ...?
Exactly
OK ...
Attached is the modification with your Version 2 ...
Hope this answers your question ...
Once you have tested the macro ... feel free to share your comments
thank you for your kind support it is working well.
Thanks for your Thanks
Don’t have an account yet? Register yourself now and be a part of our community!