AnsweredAssumed Answered

Detecting Email address in a field

Question asked by sundown on Jul 6, 2013
Latest reply on Jul 6, 2013 by 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? 

Outcomes