Validate an email address

how can i use the validation on excel to make sure valid email addresses are input into a cell

thanx!
Nitish

Hi,

I assume you want to make sure the user entry's the @ symbol. If this is correct you could try the below in your data validation.

=SEARCH("@",A1,1)

VBA Noob

thanks that seems good enuff!