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
Solved! Go to 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!