PDA

View Full Version : Solved: data validation question



vzachin
04-26-2009, 05:01 AM
hi,
this is not a vba question.

is there a way to have a cell value to be set for 8 or 11 text length?

with Data Validation, it only allows a minimum and maximum text length.


thanks
zach

Bob Phillips
04-26-2009, 05:32 AM
Choose an allow type of Custom and insert a formula of

=OR(LEN(A1)=8,LEN(A1)=11)

assuming A1 is the DV cell

vzachin
04-26-2009, 05:36 AM
hi bob,

nice. thanks for the formula

zach