Hey Guys. I have a field called name in the contact.xls file that contains the fullname. How do i separate the name into first , middle and last in an sql statement? here are some different examples. They all seem to have the same format which is a firstname space middle intitial "." then lastname

Richard M.Rewser Jr.
Laura L.San
William M.Mackian
Jon P.Gaynor II

Thanks guys

see attached message for details of how to use formulas to split text and also how to use the vba alternative.