If you want to parse that way, Data/ Text to Columns/ Delimited is probably
the best method.
--
David Biddulph

"Jon M" wrote in message
...
Trying set up worksheets for use in access.

Sheet A has a list of doctors and their practices, i.e., Name= Smith, John
I., Practice= Anytown Pediatrics

Sheet B has a list of patients and their admitting doctor, but in this
case,
it's Smith, John I (no period).

Trying to get to a result of associating the admitted patients to
appropriate practices. I think the best is to parse the MD cell by the
comma
safter the last name but thought I would ask here for advice and
assistance.

Can anyone help me out?
Thanks!!!!