Thread: Looking for @
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
reno reno is offline
external usenet poster
 
Posts: 93
Default Looking for @

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