Data Validation with letters and numbers

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

Guest

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