Trying to design a formula that will tell me if a text string contains any of the characters in a specific range. The range (named INVALID_ CHARACTERS) contains the values "!", "@", "#", "^", "(", ")", "_", ",", "." (without the quotes). Each character is in a separate cell, range INVALID_CHARACTERS) is D1:D9. For example, if cell A1 contains the value "a#d1" the value in cell B1 would by "yes". I thought the FIND () function could be used but can't get it to work using a range as first argument.