How to create a Unique code in excel/How to generate random character strings in a range in Excel
How to create a Unique code in excel/How to generate random number strings in a range in Excel
Here is quick method to generate randomly 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 display 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 the this formula: =CHAR(RANDBETWEEN(65,90)). This formula can generate a random letter from a to z, if you need to create four random letters, you need to use & character to add the letters. Such as =CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)). Then you will get a 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/...
In questa pagina del sito puoi guardare il video online How to create a Unique code in excel/How to generate random character strings in a range in Excel della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Shuaib Khan 03 ottobre 2017, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 20,189 volte e gli è piaciuto 56 spettatori. Buona visione!
