H Team, I have a long list in which I need to remove prefix from names. Some examples ae below. Kindly refer table and help me to achieve target. NameTargetMR amaramarMramaramarMRS TmirTmirMRSTmirTmirDR simonsimonDRsimonsimonPROF HasanHasanPROFHasanHasanMISS TomarTomarMISSTomarTomarMRS TomaTomaMRSTomaTomaMS DrawingDrawingMSDrawingDrawingDrawerDrawerSawerSawerHaseen MSHaseenTaken love mrTaken loveTaken love mrsTaken loveTaken love msTaken loveTaken love mrsTaken loveTaken love drTaken loveTaken love profTaken loveShakenShakenMohammad MustkeemMohammad Mustkeem Names.xlsx

Removing Prefix from Names

H Team,

I have a long list in which I need to remove prefix from names. Some examples ae below. Kindly refer table and help me to achieve target.

Name	Target
MR amar	amar
Mramar	amar
MRS Tmir	Tmir
MRSTmir	Tmir
DR simon	simon
DRsimon	simon
PROF Hasan	Hasan
PROFHasan	Hasan
MISS Tomar	Tomar
MISSTomar	Tomar
MRS Toma	Toma
MRSToma	Toma
MS Drawing	Drawing
MSDrawing	Drawing
Drawer	Drawer
Sawer	Sawer
Haseen MS	Haseen
Taken love mr	Taken love
Taken love mrs	Taken love
Taken love ms	Taken love
Taken love mrs	Taken love
Taken love dr	Taken love
Taken love prof	Taken love
Shaken	Shaken
Mohammad Mustkeem	Mohammad Mustkeem

Names.xlsx

Regex

Accepted answers

grazitti_sapna

@mmustkee , Please dinf one way to resolve your problem using formula and regex_replace function:

Salutation_Remove.yxmd

All comments

DenisZ

I could suggest using the find and replace tool here

prefix.yxzp

grazitti_sapna

@mmustkee , Please dinf one way to resolve your problem using formula and regex_replace function:

Salutation_Remove.yxmd

mmustkee

Thanks a lot for your quick response.

mmustkee

HI Thanks for your reply but find and replace will not work.

Suppose if we have these prefix in the middle of the name like Thoms, Thmrsasa, mdram, then it will remove middle prefix as well.

Do you have another solution for the same.

mmustkee

Hi Sapna,

Hi,

Sorry to bother you but when I applied this on my file it deleted these prefix from middle of the name as well. I just want these prefix to be removed from starting of the name and from end of the name with or without space. Please refer name below:

Thomsds

Thmrsasa

Kindly help..

DenisZ

@mmustkee

I believe if you enter a blank space before and/or after Mr etc. in the formula tool, then it could solve the problem.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703