multiple data validation criteria

[Guest]

I have to restrict the number of characters in a cell that already has a data
validation criteria of selecting from a named range. How do I apply the
second criteria of saying that this selection now must be equal to 30
characters (I need to export to a text file that requires specific character
lengths for each data element gathered).

 

[Dave Peterson]

Since you're using data|validation and a list, couldn't you just make sure that
each entry in that list is exactly 30 characters.

I'm not sure how you would reconcile that the string has to match something on
the list--and at the same time be 30 characters long--if those entries on the
list aren't 30 characters long.

 

[Guest]

The selections are from a very specific list - so the response choices are
limited. But I guess a space counts, though? So if I had a yes or no drop
down and it had to be three characters long, I would just have no with a
space? Is that what you mean?

 

[Dave Peterson]

That's exactly what I mean.

The selections are from a very specific list - so the response choices are
limited. But I guess a space counts, though? So if I had a yes or no drop
down and it had to be three characters long, I would just have no with a
space? Is that what you mean?