email address validation

[canablitz]

how can i get a cell to only accept email addresses, e.g letters and or numbers, then @ then more leters and or numbers, then . three letters

please help me

BoB

[Aladin Akyurek]

On 2002-04-01 08:13, canablitz wrote:
how can i get a cell to only accept email addresses, e.g letters and or numbers, then @ then more leters and or numbers, then . three letters

please help me

BoB

Three possibilities:

[1] You have a preset list of e-mail addresses against which you validate the user entry, using the formula:

=COUNTIF(AdrList,B2)

where Adrlist is the name you assign to the range that houses the e-mail addresses and B2 is the cell in which the user types an address entry.

[2] You feed the entry to a mail-client and capture and evaluate the feedback from the mail client. [Hard, Requires VBA.]

[3] Check for @, which boils down to a partial validation. BTW, a . followed by a 3-letter is wrong, unless you'd refuse doe@homenet.nl as a valid address.

Aladin

[canablitz]

[3] Check for @, which boils down to a partial validation. BTW, a . followed by a 3-letter is wrong, unless you'd refuse doe@homenet.nl as a valid address.


how exactly do i go about doing this?

[/quote]

[Aladin Akyurek]

On 2002-04-01 09:08, canablitz wrote:


[3] Check for @, which boils down to a partial validation. BTW, a . followed by a 3-letter is wrong, unless you'd refuse doe@homenet.nl as a valid address.

how exactly do i go about doing this?

Activate B2, supposing that B2 is the cell where the user enters an e-mail address.

Activate Data|Validation.

Choose Custom for Allow.

Enter as formula:

=AND(ISNUMBER(SEARCH("@",B2)),ISNUMBER(SEARCH(".",B2)))

Click OK.

Note. This is really a too limited validation.