How to create a Unique code in excel/How to generate random character strings in a range in Excel

Publicado em: 24 Março 2017
no canal de: Shuaib Khan
131,439
467

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/...  


Nesta página do site você pode assistir ao vídeo on-line How to create a Unique code in excel/How to generate random character strings in a range in Excel duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Shuaib Khan 24 Março 2017, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 131,439 vezes e gostou 467 espectadores. Boa visualização!