I know this subject has been covered ad nauseum on these groups but I
cannot find a solution to my specific situation.
I inherited a database that has names kept in one field. I need to
break this out into 4 fields. The format of the names is pretty
consistent but the 4 possible names are not always there. The format
is "LastName, FirstName MiddleInitial Suffix" (Weird I know but true).
If all fields had all 4 possibilities then I would know what to do but
some only have Last, First some Last, First Middle, etc. That kind of
logic is beyond my VBA skills. Please help.