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

Опубликовано: 24 Март 2017
на канале: 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/...  


На этой странице сайта вы можете посмотреть видео онлайн How to create a Unique code in excel/How to generate random character strings in a range in Excel длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Shuaib Khan 24 Март 2017, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 131,439 раз и оно понравилось 467 зрителям. Приятного просмотра!