Hi all!
Suggest please
1. how randomly concatenate digits in six (or more) different cells in order to generate 6 (or more) digit promo code? Can I make it happen with formulas only or need to use VBA?
2. How to adjust formula CHAR(RANDBETWEEN(65,90)) in green cell in order to exclude from the results I and O digits?
Please see the Excel file attached.
Thanks in advance for help!
Last edited by John7777; 08-29-2016 at 03:47 PM.
In B2, C2, D2 and E2 =MID("ABCDEFGHJKLMNPQRSTUVWXYZ",RANDBETWEEN(1,24),1)
In F2 and G2 =RANDBETWEEN(0,9)
If you want to exclude 0 and 1 as well as I and O then use =RANDBETWEEN(2,9) instead.
Then concatenate the results.
=B2&C2&D2&E2&F2&G2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks