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/...
On this page of the site you can watch the video online How to create a Unique code in excel/How to generate random character strings in a range in Excel with a duration of hours minute second in good quality, which was uploaded by the user Shuaib Khan 03 October 2017, share the link with friends and acquaintances, this video has already been watched 20,189 times on youtube and it was liked by 56 viewers. Enjoy your viewing!
