Excel. My Cell Must Contain An '@'
 

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.

Excel. My Cell Must Contain An '@'
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Karl Gibbon" schrieb im Newsbeitrag
om...
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.