Hi,
Please can someone advise how I can create a Data Validation that allows only Alphanumeric cell entry.
1 letter, 2 numbers
eg T11,
I need to apply this to cell C3 to C36
Regards,
Andy
Hi,
Please can someone advise how I can create a Data Validation that allows only Alphanumeric cell entry.
1 letter, 2 numbers
eg T11,
I need to apply this to cell C3 to C36
Regards,
Andy
Hi look into attachment it is data validation with formula
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Excellent thanks very much Tom1977.
However I'm still able to enter 3 numbers into a cell. Is it possible to ensure the 1st character has to be a letter?
Regards,
Andy
Hi try this version then
Thank you. Much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks