How can I show text and numbers in data validation? i.e. L1234

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want people that use my spreadsheet to HAVE to enter a letter followed by
three numbers. I usually use data validation for tasks like this, however, I
can't figure out have to enforce a custom format of "letter, number, number,
number".
 
One way:

Allow: Custom
Formula: =AND(LEN(A1)=4, CODE(UPPER(LEFT(A1,1)))>=65,
CODE(UPPER(LEFT(A1,1)))<=90, ISNUMBER(--RIGHT(A1,3)))
 

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

Data Validation to exclude blank cells 6
Postcode Validation 4
Data Validation? 2
data validation and formatting 1
Field Validation for Length & Character Type 3
Format Cell and Data Validation 4
Select Specific Data From Cells For A Chart 4
Data Validation 2

Back
Top