Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelHow to generate random strings in Excel?

# How to generate random strings in Excel?

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))

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021