check if substring (from one column) exists in another text (other column) while ignoring characters

[Anonymous]

check if substring (from one column) exists in another text (other column) while ignoring characters -  Space, comma, hyphen, quote,  non case sensitive etc

[nandukrishnavs · Accepted solution]

@Anonymous 

Try CONTAINSSTRING()

CONTAINSSTRING(<within_text>, <find_text>)

If you want to remove special characters from the text, you can use SUBSTITUTE().

SUBSTITUTE(<text>, <old_text>, <new_text>, <instance_num>)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂