remove credentials from name

[Neuronal Nerd]

Hi Group,

I'm trying to figure out a calculation to remove ones credentials from their name. My database contains mostly physicians names in a single field called Referral.

The names have been entered using various formats, including: FirstName LastName, MD; FirstName MiddleInitial LastName, MD; or CompanyName. Some have different credentials: Psy.D., DO, Ph.D., or NP. Some of them have periods in their credentials and others don't.

How can I extract just the name from this data? The reason that I need to do this is because some insurance companies will reject a claim if it has credentials listed in the name of the referral source (sound frivolous? I totally agree -)).

Thanks, Brad

Edited September 4, 2008 by Guest

[Neuronal Nerd]

To answer my own question, I just found the Substitute function. This ought to do, but any other recommendations are still welcome! thanks, Brad

[Lee Smith]

This topic comes up from time to time. See if this Thread helps Link.

Lee