Hello,
I am trying to create a data validation formula that will only allow the following characters, 0-9 and A-F.
ABCD1230AD89 TRUE
ABCD1234AD90 TRUE
ABCD1234AD91 TRUE
ABCD1234FD92 FALSE
AJCD1234AD93 FALSE
ABCD1234GH94 FALSE
I have been trying combinations of ISNUMBER, SEARCH, LEFT, FIND, ISERROR and I get stuck for example when I say allow E, however if E isn't listed then the result is FALSE...
Any help would be greatly appreciated.
Thank you,
Mindy
Bookmarks