View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 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.