How to create random passwords, codes, strings by mask in Excel 2010 - 2000

 

Random Generator for Microsoft Excel

Excel: Create random strings of any pattern, passwords, codes


How to generate strings of a given length

  1. In your Excel worksheet, select a range that you want to fill with random strings. Click here to see how to select a range.
  2. On the Random Generator pane, go to the Strings section. Click the arrows next to the Strings to expand the section. Click the arrows for expanding the Strings section
  3. Select the necessary character set(s). There are letters in upper and lower case, numbers, space, certain characters like punctuation marks with some commonly used symbols, and Hexadecimals that you can choose from. Select the necessary character set
  4. If you need to generate strings using only certain characters, check the Custom checkbox and type or copy / paste these characters. You can use this option alone or in combination with other character sets. Tick the Custom checkbox to generate strings with certain characters
  5. Click the string length radio button to set the string length. You can enter it manually or select it by clicking the up and down arrows: Set string length in this field The strings can be from 1 to 99 characters long.
  6. Click on the Generate button Click this button to fill in the range.
  7. If you want to change the generated random strings in the selected range, just press Generate again and these values will be automatically replaced by new ones.

How to generate strings using a pattern (by mask)

  1. In your Microsoft Excel worksheet, select a range that you want to fill in. Click here to see how to select a range.
  2. On the Random Generator pane, go to the Strings section. Click the arrows next to the Strings to expand the section. Click the arrows for expanding the Strings section
  3. Select the necessary character set(s): letters in upper and lower case, numbers, space, certain characters like punctuation marks with some commonly used symbols, and Hexadecimals. Select the necessary character set
  4. If you need to generate strings using only certain characters, check the Custom checkbox and type or copy / paste these characters. You can use this option alone or in combination with other character sets. Generate strings by mask using custom characters
  5. You can set the pattern using the By mask option. Press the By mask radio button and enter a pattern. A question mark (?) stands for one character. E.g. if you need to get a string like this " F0E3-AD27-53A0", use the following mask "????-????-????" Select strings By mask and enter a pattern
  6. You can also have constant symbols in your strings when generating them by mask. Here is an example: you want the first 3 characters in the strings to be 000. So all you do is type in this mask: 000-????-????. Have invariable symbols in the strings generated by mask
  7. You can also use one of the default templates. Click the down arrow next to the By mask option to select one of the suggested patterns. Choose a pattern in the By mask drop-down list
  8. Click on the Generate button Click this button to fill in the range.
  9. If you want to change the generated random values in the selected range, just press Generate again and these strings will be automatically replaced by new ones.

See also

 
 
 
 
 
 

Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.




 

License Benefits

  • 30-day money-back guarantee
    If not satisfied, you'll get your money back, no questions asked.
  • 1 license for 3 PCs
    You can install 1 license on 3 PCs: at work, at home and on a laptop.
  • Life-time licenses
    There are no annual or renewal fees.
  • Get the product in minutes
    Instant delivery for credit card payments.
  • All forms of payment
    Pay with any major credit card, wire transfer, Purchase Order, PayPal.
  • Discount for schools & NPO
    Contact us to get your coupon code.
  • Volume discounts
    You can save up to 50%.
  • Free upgrades
    All minor updates are free. Major upgrades are free for 1 year, after 1 year - for half price.
  • Code signed with VeriSign
    The add-ins are signed with the VeriSign Code Signing certificate.
  • Easy corporate deployment
    Please see Installing an add-in for several users
  • Free support
    If you need any help, just contact us.
 
Excel Add-ins Collection - quick way to increase your effectiveness in Excel

Related links





Plug-ins for Microsoft Excel and Outlook

Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.