Extracting names and suffixes
The many variations, unfortunately, will require manual processing on
your part. The best way to start that I can think of is to use the
Text To Columns feature and parse the data using the blank space as
delimiter. That will get individual words (Title, Fname, Lname,
degree, etc) into individual columns.
Then, perform a sort of all rows, sorting on column D. This will get
all the FName LName Degree people into one area. Segregate that data,
then sort the remaining rows on Col E, then F etc., handling the
information in groups step by step.
|