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

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

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

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

In article ,
lhaen wrote:

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