Split Sort cell values in Excel - either Macro or VBA
Posted on 2014-04-30
I have thousands of cells with the following name in this format in each cell:
This is the general format and the first and surname is always separated by a comma.
Can I switch and actually separate these out so I have firstname in one cell and surname in another - something like this?
It would be great to have either as a macro or vba script I can run?
Thanks in advance - GISVPN