Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello-I have a column with 500 rows with people's emails. Some of those rows do not have the "@" value. Can I create a formula that will tell me which row does not have the "@" value? Any help would be great.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Let's say that the e-mail addresses are in column A, starting in A2.
    In B2, enter the following formula:

    =IF(ISERROR(SEARCH("@",A2)),"***","")

    and fill down as far as needed. The formula will return *** in rows where column A doesn't contain a @.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='Seba' post='771859' date='22-Apr-2009 17:30']Hello-I have a column with 500 rows with people's emails. Some of those rows do not have the "@" value. Can I create a formula that will tell me which row does not have the "@" value? Any help would be great.[/quote]
    Why not use
    ... "Data > Filter > Autofilter "Does not contain"?
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •