Can you post some more of your data? It's hard to figure out the best
method for the job without more samples.


Thx,
JP

On Feb 12, 3:19*pm, "
wrote:
sample field:
HYDROXYZINE PAM TYA** 2 DOE, JOHN

sample output:
DOE, JOHN

I would like to pull out the name from the field above. *Cutting point
should be at the nearest space preceding the last comma.

I'm having trouble wrapping my brain around it. *I'd prefer to do it
with functions rather than VB script, but will be glad with either
solution.

Your help is very appreciated.

--T