Remove String In between special characters.

[Ajith1]

I have an input like :

Ajith, Mr. Raja

Ram, Ms. Reddy
Raji, Miss. Jan

OutPut Like

AjithRaja

RamReddy
RajiJan

I need to Remove in between special characters Like, Mr. 
Is it possible? by using the Single Regex formula

[marcusblackhill · Accepted solution]

Hey @Ajith1 !

Well, if you know all possible words between the first and last name, you can add in that formula:

REGEX_Replace([Field1], "Mr\.|Ms\.|Miss\.|Mister\.|,|\s+", "")

Look the attached example.

Hope that helps!

[messi007 · Accepted solution]

@Ajith1,

Please see below:

Attached the workflow,

Regards,