I have to deal frequently with data containing a column with several names written like this:
SURNAME Name
DOE John
DE NIRO Robert
SMITH Robert James
I need to rewrite them al in this format:
SURNAME N.
DOE J.
DE NIRO R.
SMITH R.J.
So I need to keep intact the uppercase part and put a dot after every first letter on the name/s.
How should I arrange a macro (or a sequence of macros) to do this?
SURNAME Name
DOE John
DE NIRO Robert
SMITH Robert James
I need to rewrite them al in this format:
SURNAME N.
DOE J.
DE NIRO R.
SMITH R.J.
So I need to keep intact the uppercase part and put a dot after every first letter on the name/s.
How should I arrange a macro (or a sequence of macros) to do this?