title: Disallow special characters except '@' in email validation formula
body: <p>I have this formula which validates the email address for Excel:</p>
  
  <pre><code>=AND(ISERROR(FIND(" ",[Send Report To],1)),IF(ISERROR(FIND("@",[Send Report To],2)),FALSE,AND(ISERROR(FIND("@",[Send Report To],FIND("@",[Send Report To],2)+1)),IF(ISERROR(FIND(".",[Send Report To],FIND("@",[Send Report To],2)+2)),FALSE,FIND(".",[Send Report To],FIND("@",[Send Report To],2)+2)&lt;LEN([Send Report To])))))
  </code></pre>
  
  <p>But fails when I enter this email id: <code>sandy,rocks@gmail.com</code> or <code>sandy.rocks@gmail,co.uk</code>.</p>
  
  <p>Can anyone amend the validation formula above so that it avoids the special characters like commas within the email address? </p>