+ Reply to Thread
Results 1 to 3 of 3

Email condition

  1. #1
    nick
    Guest

    Email condition

    Hi can someone help me build a formula in excel woth the following condition
    plz?

    Rule for a valid email id:
    If input is blank or invalid, then pass ‘/’. Special characters other than
    ‘@’ to be avoided.
    ‘.’ At end is not allowed. At least one ‘.’ Should be there after ‘@’ and
    ‘..’ not allowed.

    Thanks a bunch

  2. #2
    Ardus Petus
    Guest

    Re: Email condition

    Try:
    http://www.google.fr/search?num=100&...xp+email&meta=

    HTH
    --
    AP

    "nick" <nick@discussions.microsoft.com> a crit dans le message de news:
    BCC2217E-11B1-4E00-ACAA-AA51FD83EA7B@microsoft.com...
    > Hi can someone help me build a formula in excel woth the following
    > condition
    > plz?
    >
    > Rule for a valid email id:
    > If input is blank or invalid, then pass '/'. Special characters other than
    > '@' to be avoided.
    > '.' At end is not allowed. At least one '.' Should be there after '@' and
    > '..' not allowed.
    >
    > Thanks a bunch




  3. #3
    Ardus Petus
    Guest

    Re: Email condition

    Sorry: that was a french google search.
    Try your local google upon Regexp email

    --
    AP

    "Ardus Petus" <ardus.petus@laposte.net> a crit dans le message de news:
    upjOBTJlGHA.4212@TK2MSFTNGP03.phx.gbl...
    > Try:
    > http://www.google.fr/search?num=100&...xp+email&meta=
    >
    > HTH
    > --
    > AP
    >
    > "nick" <nick@discussions.microsoft.com> a crit dans le message de news:
    > BCC2217E-11B1-4E00-ACAA-AA51FD83EA7B@microsoft.com...
    >> Hi can someone help me build a formula in excel woth the following
    >> condition
    >> plz?
    >>
    >> Rule for a valid email id:
    >> If input is blank or invalid, then pass '/'. Special characters other
    >> than
    >> '@' to be avoided.
    >> '.' At end is not allowed. At least one '.' Should be there after '@' and
    >> '..' not allowed.
    >>
    >> Thanks a bunch

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1