Hi,

Could you please explain how to enter your results within a cell to validate
for inputting correct address. I would really appreciate an email response,
candid, I know but I am really stuck on this one.

Kind Regards,

Gerry

"BethP" wrote:

Hi Scott,
Thanks again. With your help and a couple other posts in this board, I was
able to hack this together! Here is what I have:

1. Test that it's a text string
ISTEXT(A2)
2. Test for the position of "@" in the text string (A)
FIND("@",A2)
3. Count occurrences of "@" in test string (nullify if <1)
AND((SUMPRODUCT(--(LEN(A2)-LEN(SUBSTITUTE(A2,"@","")))))=1)
4. Test for the position of "." in the text string (B)
FIND(".",A2,C2+1)
5. Test that neither A or B are NA#
SUM(C2:E2)
6. Test that there is text before A
C21
7. Test that there is text between A and B
E2-C21
8. Test that there is text after B
LEN(A2)E2
9.Does not contain a space
ISERR(NOT(FIND(" ",A2)))
a result of False means that at least one of the tests has failed
IF(ISERR(AND(B2:J2)),"",(AND(B2:J2)))