Andreas Hermle
asked on
Extract titles from string using VBA
Dear Experts:
I got a huge data list with column headers where the (German) titles need to be extracted from a string in Column G:
Now the strings in Column G say for example:
Prof. Dr. Dr. med. John Doe
Prof. Dr. Elvis Costello
Prof. Jane Forseth
Dr. Miriam Sensing
I would like to run a macro that searches for the following strings (only! whole terms, no parts of the strings) ...
... Prof. Dr. Dr. med.
... Prof. Dr.
... Prof.
... Dr.
and extracts the found strings and inserts them in column H in the respective row.
The original string in Column G is to remain the same.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I got a huge data list with column headers where the (German) titles need to be extracted from a string in Column G:
Now the strings in Column G say for example:
Prof. Dr. Dr. med. John Doe
Prof. Dr. Elvis Costello
Prof. Jane Forseth
Dr. Miriam Sensing
I would like to run a macro that searches for the following strings (only! whole terms, no parts of the strings) ...
... Prof. Dr. Dr. med.
... Prof. Dr.
... Prof.
... Dr.
and extracts the found strings and inserts them in column H in the respective row.
The original string in Column G is to remain the same.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear Rgonzo,
I am truly impressed! :) this works just great!
This is real coding professionalism. Thank you very much for your great support.
Regards, Andreas
I am truly impressed! :) this works just great!
This is real coding professionalism. Thank you very much for your great support.
Regards, Andreas
ASKER
thank you very much for your swift and professional help. Looks very,very sophisticated to me.
Okay, I'll give it a try and let you know.
Regards, Andreas