How to generate offer codes or vouchers or promo codes in Excel with Formulas
How to create a Unique code in excel/How to generate random character strings in a range in Excel
Here is a quick method to generate random alphanumeric texts in Excel. A good lesson for beginners.
The following formulas can help you generate random numbers, letters, and alphanumeric values in a range in Excel.
1. To create a random 5-digit number between 10000 and 99999, use this formula: =RANDBETWEEN(10000,99999), and press Enter key, a 5-digit number will be displayed in a cell, then select the cell and drag the fill handle across to the range that you want to contain this formula, a range of 5-digit numbers have been generated,
2. To create a random letter, use this formula: =CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9). This formula can generate a random letter from a to z and 1 to 9, if you need to create four random letters, you need to use & a character to add the letters. Such as =CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9) and then join all the colums =TEXTJOIN("-",,range). Then you will get four random letters, and then drag the fill handle over to the range that you want to contain this formula.
Note: you can change the arguments to get your need.
How to create a Unique code in excel/How to generate random character strings in a range in Excel
Here is a quick method to generate random alphanumeric texts in Excel. A good lesson for beginners.
The following formulas can help you generate random numbers, letters, and alphanumeric values in a range in Excel.
1. To create a random 5-digit number between 10000 and 99999, use this formula: =RANDBETWEEN(10000,99999), and press Enter key, a 5-digit number will be displayed in a cell, then select the cell and drag the fill handle across to the range that you want to contain this formula, a range of 5-digit numbers have been generated,
2. To create a random letter, use this formula: =CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9). This formula can generate a random letter from a to z and 1 to 9, if you need to create four random letters, you need to use & a character to add the letters. Such as =CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1,9) and then join all the colums =TEXTJOIN(“-“,,range). Then you will get four random letters, and then drag the fill handle over to the range that you want to contain this formula.
Note: you can change the arguments to get your need.
){kind=link}
Comments