2 Replies Latest reply on Jul 6, 2013 3:41 PM by sundown

    Detecting Email address in a field

    sundown

      Title

      Detecting Email address in a field

      Post

           I have a group of clients listed in a table including a field that we enter their Email address. I want to add a field of 1's or 0's that detects if that client has an Email address or not (so I can sort them for mailings or emails). I am currently using the IsEmpty function but sometimes there is a "none" entered & the function only works on empty cells. Is there a function that will better detect an email address such as finding if there is a "@" in the cell?