Searching special character using "FIND"
Just want to clarify if I can use FIND function to identify a special character.
So I want to check if the string contain "@" ; the logic I am applying is:
Line item 2 = FIND("@xxx.com", Line item1, 1)
But it is not giving me the result. But works fine when I am setting the formula without "@".
Line item 2 = FIND("xxx.com", Line item1, 1) - this is working fine.
So I want to know that FIND does not identify the special characters is it?