Excel 4 characters alphanumeric data validation check on one excel column.

Joined
Apr 12, 2017
Messages
1
Reaction score
0
Hi all,

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.
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum :)

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.

Ask a Question

Top