Removing special characters using formula tool

[dunkindonut7777]

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

Name	Expected output
Non-payment	Non payment
Paid/Special	Paid Special

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

[Luke_C · Accepted solution]

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 solution]

@dunkindonut7777 Heres couple ways you can do this.