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/...
Sur cette page du site, vous pouvez voir la vidéo en ligne How to create a Unique code in excel/How to generate random character strings in a range in Excel durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Shuaib Khan 03 octobre 2017, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 20,189 fois et il a aimé 56 téléspectateurs. Bon visionnage!
