Email validation in excel

[theambarish]

Hello Gurus,

I have an excel column (Column A) with each row filled up with an email address.
I want to validate format of email address. Is there any formula which can provide results (Valid/Invalid) in Column B?

Thanks!
~Ambarish

 

[Sandeep Warrier]

Hello Gurus,

I have an excel column (Column A) with each row filled up with an email address.
I want to validate format of email address. Is there any formula which can provide results (Valid/Invalid) in Column B?

Thanks!
~Ambarish

See http://www.mrexcel.com/forum/showthread.php?t=423210 <input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">