Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine titles/names - how? | Excel Discussion (Misc queries) | |||
Column Titles/Names | Setting up and Configuration of Excel | |||
extracting names | Excel Discussion (Misc queries) | |||
Extracting names and suffixes | Excel Discussion (Misc queries) | |||
Extracting tab names | Excel Worksheet Functions |