I am using the formulas below to parse the fullname into a FirstName
MiddleInitial and Lastname field. This works great for the fullnames
that have a middle initial, but errors on those names without a middle
initial. How could the formulas be altered to allow for a name without
a middle initial. Thanks to those of you who replyed to my posting
yesterday. I should have been more clear about the input name.

TIA

LastName, John Q

(Comma): =FIND(",",A2)
(First Name): =MID(A2,B2+1,FIND(" ",A2, B2)-B2-1)
(Middle Name): =RIGHT(A2,1) & "."
(Last Name): =LEFT(A2,B2-1)