I don't think that there's a good way to do this.

I do my best to clean the data. I'd replace "MR " (with the space) with "Mr. ".

It's a lot of work and you'll always find more stuff to fix.

Good luck.

lkl wrote:

Can anyone tell me how to do this with TEXT...that is text that is close but
not a perfect match? For example f I see MR and MR. I want them to be called
a match, even tho one does not ahve the period (or extra spaces or Jr, etc).
Having lots of trouble with this.

--

Dave Peterson