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!
Bookmarks