Looking for @

[Reno]

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
(e-mail address removed) =" "
hellothere.com =1 (no "@" in addr)
this would probably have to be vbs and not IF
thx

 

[FSt1]

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

adjust to suit.

regards
FSt1

 

[Rick Rothstein]

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.