I have a column with lots of names, and I want to format them nicely using VBA. I've been trying to use formulas in a spare cell using LEFT, RIGHT, MID, FIND, ISERROR, etc, to get the desired result, then copy/paste the resulting formula into my VBA code, but it's getting very unwieldy, long and hard to follow.
Basically the names as it stands can be anything from:
SMITH, JOHN M.
TAYLOR, CHRISTOPHER (Chris)
SMYTH, EDWARD E. (Ted)
I want to format them so that they become First Initial. Surname, unless there's only one word, then I want it left as-is. And I need the whole thing converted to Proper case.
So in the example above, the finished result should be:
Also posted here: