Forum Discussion
EXTRACT text String
Good Afternoon How can I extract common titles from a text string in an Excel cell, copy the title to another cell, remove the title from the original text string? As an example, I have about 15 com...
Can you provide a list of all unique titles that occur in your data?
Hi Hans,
Thank you. I read some of your work on other posts. Wow!
Title
Father
DRE
TEACHER
FINANCE MANAGER
PRINCIPAL
DCN
DR
DR.
Dr
Dr.
MSGR
Presch Director
OTHER
MR
CATECHIST
MR.
MRS
MRS.
MS
Mr
Mrs
FR
Msgr
SR
Thank you. I read some of your work on other posts. Wow!
Title
Father
DRE
TEACHER
FINANCE MANAGER
PRINCIPAL
DCN
DR
DR.
Dr
Dr.
MSGR
Presch Director
OTHER
MR
CATECHIST
MR.
MRS
MRS.
MS
Mr
Mrs
FR
Msgr
SR
Try OliverScheurich's suggestion - enter your list of titles in C2 and down, and adjust the range $C$2:$C$8 to your range of titles.
Remark: list the longer versions of a title above the shorter versions: DR. above DR and MRS. then MRS then MR. then MR
The formula is case-insensitive so you only need to include one of DR Dr and dr (any one).