I need help to validate that the data in excel column is always a 4 characters alphanumeric only.
eg: abc1
ADG2
123R
1we2
2WER
3ER3
etc
Kindly help in this by giving function to accomplish this check.
thanks in advance.
LEN(A1)=4 would give you the length, so you could combine it with another formula using AND to only allow letters and numbers.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.