New answers tagged

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