New answers tagged regex
0
Use len(), like this:
=or( len(A2) = 5, len(A2) = 7) )
If you additionally need to ensure the value is a number, add isnumber(), like this:
=or( len(A2) = 5, len(A2) = 7) ) * isnumber(A2)
Only add a regexmatch() to the formula if you need to check for the presence of a certain digit/letter sequence or some such pattern.
Top 50 recent answers are included