have a list of ~40K e-mail addrs want to use helper cell to identify bogus or
e-mail addrs in error. where a1 is e-mail addr
want to IF (A1 < contain "@" then 1, else " ")
would yield if a1 were
=" "
hellothere.com =1 (no "@" in addr)
this would probably have to be vbs and not IF
thx

hi
see if this will work for you
=IF(ISERROR(FIND("@",A1)),1,"")

adjust to suit.

regards
FSt1

"Reno" wrote:

have a list of ~40K e-mail addrs want to use helper cell to identify bogus or
e-mail addrs in error. where a1 is e-mail addr
want to IF (A1 < contain "@" then 1, else " ")
would yield if a1 were
=" "
hellothere.com =1 (no "@" in addr)
this would probably have to be vbs and not IF
thx

What about using Conditional Formatting instead? Assuming your addresses are
in Column A, select column A, click Format/Conditional Formatting from
Excel's menu bar, select "Formula Is" from the first drop down and
copy/paste this into the blank field next to it...

=AND(ISERROR(FIND("@",A1)),A1<"")

Then click the Format button on the dialog box, select the Patterns tab and
pick a color you like (I'd suggest a pale color so you can easily see the
text through it), then OK your way back to the worksheet. Any cells in
Column A whose entry does not contain an "at" symbol will be highlighted in
the color you selected.

--
Rick (MVP - Excel)


"Reno" wrote in message
...
have a list of ~40K e-mail addrs want to use helper cell to identify bogus
or
e-mail addrs in error. where a1 is e-mail addr
want to IF (A1 < contain "@" then 1, else " ")
would yield if a1 were
=" "
hellothere.com =1 (no "@" in addr)
this would probably have to be vbs and not IF
thx