| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 address they don't just type 'adfsdfsfdsdf' or something and if they do they the cell won't accept it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrow keys moving whole excel sprdsht insted of from cell to cell | New Users to Excel | |||
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
| copy excel cell to cell in word table using excel macro | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| How do I make my arrow buttons move from cell to cell in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
