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

Publicado el: 24 marzo 2017
en el 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/...

En esta página del sitio puede ver el video en línea How to create a Unique code in excel/How to generate random character strings in a range in Excel de Duración hora minuto segunda en buena calidad , que subió el usuario Shuaib Khan 24 marzo 2017, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 131,439 veces y le gustó 467 a los espectadores. Disfruta viendo!