Test if a Cell contains either of 12 different words
Hi Joy
Try the Select Case statement
Not sure how to test with embedded text though - something for me to play
with and find out
HTH
"J@Y" wrote:
I'm trying to test if a cell contains any of 12 different words (note the
words may be embedded in a phrase). Is there an easier way than to write 12
if statements?
Thanks.
|