A
andreashermle
Dear Experts:
I got a client list (German names) where the whole name including
title is in just one cell, such as
Dr. med. Betty Eastwood
Prof. Dr. Dr. Joe Doe
Dr. John Westwood
Dr. phil. Robert Friedman
I know how to extract the first occurrence of a word and the last one,
i.e. in the first example "Dr." and "Eastwood". But how to extract the
ones that are in between (one to three occurrences).
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I got a client list (German names) where the whole name including
title is in just one cell, such as
Dr. med. Betty Eastwood
Prof. Dr. Dr. Joe Doe
Dr. John Westwood
Dr. phil. Robert Friedman
I know how to extract the first occurrence of a word and the last one,
i.e. in the first example "Dr." and "Eastwood". But how to extract the
ones that are in between (one to three occurrences).
Help is much appreciated. Thank you very much in advance.
Regards, Andreas