Data Validation (Text length) (1 Viewer)

[matt330]

How would I write an expression to limit a text length to either 3 or 7 digits?

Thanks in advance

 

[shades]

Howdy. Are you wanting to limit what can be displayed? Or entered? You

Select the cell (say, A2), then on the menu go to Data > Valaidation and in the dropdown box, choose "Custom". In the formula box, put this:

=OR(LEN(A2)=3,LEN(A2)=7)

Now, this will limit the length to either three or seven digits.
________
Vaporizers

 

[matt330]

That's exactly what I'm looking for Shades - thanks for your help.