email address validation
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: email address validation

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [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]

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    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.


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com