This returns Lastname
=LEFT(A1,FIND(",",A1,1)-1)

This returns Firstname
=MID(A1,FIND(",",A1,1)+1,LEN(A1)-2-FIND(",",A1,1))

This returns MI
=RIGHT(A1,1)

Vaya con Dios,
Chuck, CABGx3



"ksh" wrote:

I have a column of cells containing 'Lastname,FirstName MI'. I'd like to
split this into 3 columns to better utilize in a mailmerge. Any help is much
appreciated.