Reversing convoluted names (easier said than done!)

[RobMerr]

Hello,

After MANY grueling hours of research (very hard to with particular keywording in Google), I've decided I'm in over my head.

My objective is to reverse full names and eliminate any middle initials as well as any "TTEE", "CO-TTEE", or additional clutter. The easy part (at least to me!) is I would like to PROPERNAME the names eventually as well.

For example, I would like to change the following sample list from:

BENNETT III CHARLES D
RABOW TTEE JULIAN M
PYBURN JANICE C
LIMPERT RICHARD P CO-TTEE
MARAVIGLIA CO-TTEE RAYMOND J
LEVINE WILLIAM T
SLANSKY JERRY W
SEAVER TTEE ELIZABETH M
KASE RICHARD
FLOWERS CAROL L S
DEMBO TTEE DONALD H
MC GRATH JOHN
FINSTAD PAULA M
MINION MAUREEN M
DE SOUZA TTEE VICTOR B
WHITAKER-VOLTURO DEBRA S
EPSTEIN RICHARD L
TERAMANA ALBERT J
WESTERVELT HARVEY H
HARRIS BARRY
BURNETTE TTEE DONNA J
HOAGLAND DIANE
ANDERSON BRIAN J


To:

Charles Bennett III
Julian Rabow
Janice Pyburn
Richard Limpurt
Raymond Maraviglia
William Levine
Jerry Slanksy
Elizabeth Seaver
Richard Kase
Carol Flowers
Donald Dembo
John Mc Grath
Paula Finstad
Maureen Minion
Victor De Souza
Debra Whitaker-Volturo


etc.


I deeply appreciate the help! Please let me know of any questions,

Thank you in advance,

[ragulduy]

I started off working on a formula and it quickly became unwieldy so I switched to a macro:

Please Login or Register  to view this content.

It works for all the examples in your list apart from Charles Bennett III as the proper function will also change this to Iii.

[Jakobshavn]

This can be done with VBA, but you must completely specify the rules for ordering the words.