Data Validation with letters and numbers

J

Jason

I need to ender data validation for cells B4:D189 to restrict only strings starting with "(C". Of course the strings I enter could be different lengths, so I decided to ristrict them only if they started with the first "(C". Example of my strings are (CA1), (CA2), (CA3), on up to however big (CA1343). Any help? Thanks.
 
F

Frank Kabel

Hi Jason
not quite sure I got your requierements but try the following:
- select your cells
- goto 'Data Validation'
- enter the formula
=LEFT(B4,1)="C"
 

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 - Custom question (multiple conditions) 8
VLOOKUP & Data Validation 0
custom data validation on cells with data validation values 2
How to validate a cell to insert from 9 digit number to 13 digit number. 1
Data Validation - Complex Q 2
Data Validation With Date Range 2
How to use formula to decide when to apply TIME data validation 3
Data validation: want input restricted to date value or N/A 2

Top