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

P

praseema

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.
 
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.

 
You must log in or register to reply here.

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

Similar Threads

Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Excel Help to copy information from one row at a time to another sheet 1
automated cut and paste using regex 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Data validation, mandatory and restricted field length for excel vbs 10
Excel Target.column for Data Validation would like to target some cells within column 1
VBA - retrieve data on last create named range from previous inserted named range 0
Generating a random 17-character alphanumeric string 7

Back
Top