View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rookie_User Rookie_User is offline
external usenet poster
 
Posts: 78
Default Extracting names and suffixes

I need to extract fname, lname, middle initial and suffix along with license.
The problem is the data is not all consistent - imgaine that. The data will
sometimes look like this:

Jim Case DMD
Claude G. Rick DDS
NILE P ERSLAND DDS PC
Warren Urda, D.D.S.
Don E. Burk DMD
Dr. Nicholas Feldman
MARK A JUST DDS LLC
J. Libby DDS

Any creative idea's please?