Hello
Have a look at the file attached. I used 'Data Validation' to force cell B1 to accept just numbers 1 or 2 (if A1 be equal to the word "Iamgood").
If the word "Iamgood" (in cell A1) changes to "I am good", then it does not work. It seems spaced between characters make problem for it?
Let me know your ideas.
Thanks a lot.

Attached Files

Data Validation.xlsx (8.6 KB, 10 views)