When verifying list of emails and URLs in a large sheet of contact, use the following formula below: Verifying Emails =ISEMAIL( value ) Verifying URLs =ISURL( value ) Limitation : As long as the format is correct, the result will still appear TRUE for misspelled and non-existent email address and URLs.