Excel. My Cell Must Contain An '@'

[Karl Gibbon]

I was just wondering if there was any kind of formula i could use to
ensure that the data someone enters into a specific cell contains
an'@' sign. I want to make sure that when that person enters an e-mail
address they don't just type 'adfsdfsfdsdf' or something and if they
do they the cell won't accept it.

 

[Frank Kabel]

Hi
select the cell and goto 'Data - Validation'. Choose 'custom' and enter
the following formula (for cell B1):
=ISNUMBER(FIND("@",B1))