+ Reply to Thread
Results 1 to 2 of 2

Generate random Alphanumeric with two letters and three numbers

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Generate random Alphanumeric with two letters and three numbers

    If this has been answered on here before, apologies for raising it again but I couldn't find anything,

    Attached code generates a "random" five character mix of letter and numbers.

    Please Login or Register  to view this content.
    End User is now asking for it to start with two letters followed by three digits (Yes, I have pointed out it reduces the "combination pool" significantly, but users will be users.)

    Any suggestions or solutions accepted gratefully

    Ochimus

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Generate random Alphanumeric with two letters and three numbers

    Attached code generates a "random" five character mix of letter and numbers.
    No, it doesn't.

    It errors because it appears to be missing some code. At first glance it is missing the For line.

    When you say the end user needs this do you mean someone in your company or one of you clients that you are consulting for?

    Are any characters restricted?
    Last edited by stnkynts; 03-25-2015 at 09:21 PM.

+ 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. Replies: 2
    Last Post: 11-06-2014, 05:07 PM
  2. How to generate unique random alphanumeric 32 character codes?
    By JussiR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 06:30 AM
  3. Function to Generate Random Numbers and Letters
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2010, 03:39 PM
  4. Replies: 4
    Last Post: 05-15-2010, 06:57 PM
  5. Extracting Letters and Numbers in a random Alphanumeric String
    By rajbhar_s in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2010, 08:07 AM

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