Removing mr, miss, ms, dr, prof, mrs. from the names

[mmustkee]

Hi Team,

I have table in which we have (mr, miss, ms, dr, prof, mrs.  in the last of the name with and without space. Kindly help me how to remove them without impacting name. Thanks in advance. Please refer attached sheet.

Name

Anej/drone mr

Man/Tan ms

Tejj/saja maj Dr

Man/Tan miss

asdd/wert mrs

dsdfr/grep sadmr

Anej/dronemr

Man/Tanmiss

sdf/hrsdmrs

sddff/ytdf sdfmr

[afv2688]

Hello @mmustkee ,

how about this method. I have put one with the find replace and another with the formula tool

Regards

[binuacs · Accepted solution]

Spoiler

[mmustkee]

Perfect that worked for me.

Thanks for Help.

[mmustkee]

@afv2688 

Thanks for the solution but I checked and found that it did not work for me. It deleted the value in the middle as well. I just want mentioned prefix to be deleted from the end only.

For ex. If we have (must/mr sur) it should remain the same and if we have must/surmr then 'mr' should be deleted since is coming in the end.

Thanks.

Kindly advise.

[ericlt · Accepted solution]

Maybe this workflow.

Find & Replace makes it tricky because we cannot check the field ending - so, lots of ReverseString stuff.

[mmustkee]

Perfect!