September 4, 200817 yr 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, 200817 yr by Guest
September 4, 200817 yr Author To answer my own question, I just found the Substitute function. This ought to do, but any other recommendations are still welcome! thanks, Brad
Create an account or sign in to comment