How to automatically Removing Special Characters ~ ` ! @ # $ % & * ; : ? . , ’ "

[Momin_Bannani]

I would like to remove the following special characters on the “project name”
~ ` ! @ # $ % & * ; : ? . , ’ "

UPPER(CONCATENATE(Language, “-”, Team, “-”, SUBSTITUTE({Project Name}, " ", “”), “-”, {Date Added to Airtable}))

Can someone help me :pray:

Thanks

[kuovonne · Accepted solution]

It looks like you have a great start with using the SUBSTITUTE function to remove spaces. To remove additional characters, use nested substitution functions, as demonstrated in this post on creating slugs for webpages. That post replaces the special character with their url encoded equivalents, but you can remove them entirely if you like.

[Momin_Bannani]

Thank you Kuovonne, It worked :metal: