In one of the previous blog posts , we demonstrated how you can use the function RANDBETWEEN in Microsoft Excel to generate random number in Excel. In this blog post, let’s have a look at generating random strings in Excel.
How to generate random strings in Excel ?
You can use the combination of the CHAR function and the RANDBETWEEN function to generate the random letter. For example =CHAR(RANDBETWEEN(65,90)) would generate the random character. The values 65 and 90 represent the ASCII values for the letters A and Z respectively.
Incase you need a string with 3 characters , the formula would be like this.
=CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90))