=LEFT(A1,FIND(",",A1)-1)

=SUBSTITUTE(SUBSTITUTE(A1," "&D1,""),B1&", ","")

=MID(A1,FIND("~",SUBSTITUTE(A1," ",",~",LEN(A1)-LEN(SUBSTITUTE(A1,"
","")))),99)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rod" wrote in message
ups.com...
The name field is in the following format: Abbott, Susan H.


I would like to break it out into three seperate columns like below.

Last Name First Name Middle Initial
Abbott Susan H.