|Since you stated that only one cell will contain, tel:, this formula will check A1 and return A1 if it contains tel: and then stop. If A1 doesn't contain tel:, it will check A2 and return A2 if it contains tel: and then stop. If neither A1 or A2 contain tel:, it will return A3 since that's the only cell left.|
If you need to actually check A3 because there might not be a tel: in any cell, then just add one more IF clause.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.