+ Reply to Thread
Results 1 to 2 of 2

Regular expression

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Regular expression

    Hi i want a pattern for variable which accepts values Like Abc@123, A1234#1,B7#13299i2, a1232%B etc
    so basically the first letter should always be a letter.
    It should be a combination of letter, number and only one special character.
    Atleast one letter should be in bigger case,
    The sice should be greater then 7

  2. #2
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Regular expression

    Check out:

    First a letter: combination of left and ischaracter: http://www.techonthenet.com/excel/formulas/left.php and http://techniclee.wordpress.com/2010...ction-for-vba/

    The latter will also help you finding a capital letter and the special character using the ASCII-table. Shouldn't be too complicated.

    Len: http://www.techonthenet.com/excel/formulas/len.php

    For the number, I'd check if this is greater 0:
    Please Login or Register  to view this content.

    Hope that helped to push you forward.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. regular expression for password
    By Gourav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2014, 04:05 PM
  2. [SOLVED] Regular Expression Pattern
    By goss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2013, 11:36 AM
  3. [SOLVED] Regular Expression
    By Kvramana in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 05:32 AM
  4. regular expression in vba is not working
    By johnmerlino in forum Excel General
    Replies: 2
    Last Post: 07-07-2011, 06:19 PM
  5. Regular Expression in Excel?
    By terrence_chan99 in forum Excel General
    Replies: 3
    Last Post: 01-08-2007, 10:55 PM


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