Removing special characters using formula tool

Question

Hi, I have a data here that has special characters, I want to remove it in a formula tool.

NameExpected outputNon-paymentNon paymentPaid/SpecialPaid Special

Just want to know how to formulate it in a formula tool. Thank you

Luke_C · Accepted Answer

Hi @dunkindonut7777

Here's an example using regex replace. the [^A-Za-z] means any character that is not (^) A-Z.

REGEX_Replace([Name], '[^A-Za-z]', ' ')

MilindG · Accepted Answer

@dunkindonut7777 Heres couple ways you can do this.