You might look at this entry from Anthony D where he was helping with a
similar issue (splitting names - but not quite as complex)
http://www.microsoft.com/office/comm...a-c96f22da49f7

identify the space as the 'delimiter' and see where to go from there. At
least you'll probably have the information broken into individual cells,
although you are obviously going to have to do some manual moves after that.
Even a VBA solution would be difficult because of all the vagueness involved,
as
Name may or may not have middle initial,
may have Dr. at start vs DDS at end
Variety of license identifiers involved.


"Rookie_User" wrote:

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?