I am validating a column to see if it contains blacklisted words. I want to capture the words whether they are upper case or lower case but I cannot seemed to find any solution on the internet. Does anyone know the proper syntax to ignore case? Or if I can compare the words by converting it to lower case first?

I have the following as my validation formula:


Your help is much appreciated. Thank you in advance!


I have found the answer.

=AND(IF(ISERROR(FIND("kns",LOWER([Title]))),TRUE), IF(ISERROR(FIND("lj",LOWER([Title]))),TRUE), IF(ISERROR(FIND("wah lau",LOWER([Title]))),TRUE), IF(ISERROR(FIND("lao jiao",LOWER([Title]))),TRUE))

This website shows all the synthax: http://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.