I need some assistance. I need to create a spreadsheet with 1 column and 4000 rows. In each cell I need 6 random characters (4 numerical and 2 alpha). Any suggestions on how I can do this in Excel 2003? Thanks!
I need some assistance. I need to create a spreadsheet with 1 column and 4000 rows. In each cell I need 6 random characters (4 numerical and 2 alpha). Any suggestions on how I can do this in Excel 2003? Thanks!
Hi Dcdigiacomo, welcome to the forum.
The following formula will generate random codes having 4-digits & 2 characters (always num-num-num-num-char-char). Hopefully that works for you.
=TEXT(RANDBETWEEN(0,9999),"0000")&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))
Every time the worksheet calculates these codes will change, so if you want them to remain you will have to copy them (copy A1:A4000) then select A1 and use PasteSpecial -> Values to convert the formulas to static values.
You would change the formula to:
=TEXT(RANDBETWEEN(0,9999),"0000")&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))
Awesome! Thanks for all your help and thanks from the previous user.
Last edited by Paul; 07-23-2010 at 04:19 PM. Reason: Removed quotation
how do we reverse it so that letters can be in front? and to generate 6 numbers
let me know
Rinnycop. It is forum rule that you must not post YOUR question in anothe rperson's thread (even one that is 14 years old).
Please start your OWN thread, using a suitabkle sampel fiel for us to play with,
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks