I have an excel spreadsheet with over 17,000 records. In the address field, the suite number needs to be taken out and put into its own field. Also, in the name field, the parts of the name needs to separated out and put into its own field: first name, last name and degree (DDS or DMD, etc.) Any middle initial can go with the first name.
I have attached a sample of the current list.
