Detecting Email address in a field
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?