If you are talking about the formulae to do that in the spreadsheet, here’s the way.
If a phone number has 11 characters, assuming the number is stored in A:
It must be noted that the number should be carefully formatted so that it does not lose the ‘0’ at the start in specific countries.
E.g: A phone number in Vietnam would look like 0123 456 789, when entered into Sheet as number, it will not take the 0 (as it’s not meaningful in a number context). It must be stored as text, or replace the ‘0’ with country’s prefix (in this case +84).
If an email has the @:
This FIND formula checks if the string in A has the letter “@” and returns its position. If it does not exist, the FIND formula will return a value error, hence the IFERROR to throw a 0 back instead of #VALUE!
- If an ID number has the right number of characters
Same concept with the phone number, replace the number 11 with the desired number for checking.