Excel. My Cell Must Contain An '@'

K

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.
 
F

Frank Kabel

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