Hello,
I'm trying to do the following as a formula for data validation.
The string that should be allowed in cell A1 is:
ABCnnnnnnLLLXX
ABC is the string "ABC"
n is a number
L is a capital letter
X is either a number or a capital letter
As data validation formula, I came up with the following formula:
My problem now is that the CODE function only looks at the first character of the selected area defined by the MID functions.
So far I can still enter strings like
ABCnnnnnnL%%X%
where % is any character
e.g. ABC123456A$*0£
Is there a function similar to the CODE function or is there an easier way of solving my problem?
Any help will be appreciated.
Kind regards
bondingfortoday
Bookmarks