How to create a Unique code in excel/How to generate random character 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.

[shawnastephens]

Thanks for the video! Do you know how I would do a random sequence like this..."mp-txn-3zdvTA5" where mp-txn stays the same but the letters and numbers change randomly?

[TheDornix]

How can I fix the generated code? Because it changing everytime when open the file or copy the cells. Thanks the help! :)

[komoniefe]

hello. thank you for this video. however, i noticed my codes changed . is there any way i can make it static(fixed) because i want to assign those codes to different individuals and i want to keep a record that won't change

[f-fighterjet]

good video but why do the codes change after I press the delete button on empty cells??

[fortodays]

sir kisi dusri cell me jake hum jab enter krte h to wo value chnge ho jati

[TylerCazier]

This doesn't guarantee unique keys

[gracysinghit]

Background main itna loud music dalne ki kya jarurat thi concentrate karna difficult ho jata hai