I have a list of names that are listed as last name, first name, and sometimes middle initial as in:

D2:Dn

DUNKIN STEVAN R & GINA R
LOPEZ ANTHONY
ZHANG SHENGWEI
OVALLE NELLY E
PARK CASEY H & CHRISTINE
LOINAB AHMAD Z & WAZHMA
MCCLANE CHERYL & RALPH TRUST
WALKER WILLIAM G JR & MARIE B
SONG MELVIN & DOREEN K Y

I would like to know how to swap first and last names dropping middle initial but keeping &
as in:

E2:En

Stevan & Gina Dunkin
Anthony Lopez
Shengwei Zhang
Nelly Ovalle
Casey & Christine Park
Ahmad & Wazhma Loinab
Mcclane Trust
William & Marie Walker
Melvin & Doreen Song

Note: the names are intially all caps and need to proper, and i have exemption words in column A to not change things like "trust" which i can minipulate manually because there aren't that many of them.

I know I am asking a lot but I have over 1000 names per week and am trying to streamline this process. Thanks in advance