Generate Random Letters in Excel

Ever faced a situation where you need to generate random letters?

Yes, sometimes we need to generate random letters.

We have functions like RAND and RANBETWEEN to generate random numbers but we don’t have any particular function to generate letters.

But today, I will share with you an amazing formula trick to generate random letters in excel.

And, the best part is it’s simple and easy to use.

Formula To Generate Random Letters in Excel

As I say, there is no direct function in excel which can help you to get random letters/alphabets.  But, we can use a combination of RANDBETWEEN and CHAR to create a formula to get random letters.

And, the formula will be.

  • Generate capital random letters=CHAR(RANDBETWEEN(65,90))

generate random letters with capital letters

  • Generate small random letters: =CHAR(RANDBETWEEN(97,122))

generate random letters with small letters

You can drop this formula up to the cell where you want to generate random letters.

How does this formula Generate Random Letters

Now, let me tell you how does this formula generate these letters. First of all, you have to understand that this formula works in two different parts.

how this formula generate random letters

In the first part, you have RANDBETWEEN function which can generate random numbers for you. You just have to specify the lowest number and highest number. And, it will return a random number from that range.

In short, you will get a random number in result within the range.

generate random letters edit randbetween

Now, in the second part, you have CHAR function which can return a specific character when you specify a number in it.

That means for each character there is a specific number you have to insert in CHAR function. And, numbers 65 to 90 represent capital letters and 97 to 122 small letters.

If you enter 65 in CHAR it will return “A” and for 97 it will return “a”.

generate random letters edit char

The Bottom Line is when you specify any of the above range in RANDBETWEEN it will return a random number and after that CHAR function will return a character for that number.

generate random letters drop down

This is the whole story.

Quick Tip: RANDBETWEEN is a volatile function so you need to care while using it.


Generating random letters is no big deal. And, the formula you have used above is simple and easy to apply. The best use of this method in the real world which I have found is you can use it for generating random groups for participants.

I hope you found it useful.

Now, I want to hear something from you. Do you have any other method to create random letters? Please share with me in the comment section, I would love to hear from you.

Content Protection by


  1. Joanna 8 Nov, 18 at 9:00 am - Reply

    If I want to generate a series of A’s and B’s but never more than 2 of A or B is it possible?

    • Puneet 8 Nov, 18 at 10:14 am - Reply

      Didn’t get you properly. Can you come again?

  2. Dilip Shedge 21 Nov, 17 at 8:52 am - Reply

    Thank You Sir,

  3. Emmanuel Martins 6 Sep, 17 at 7:28 pm - Reply

    Thanks again Puneet

    • Puneet Gogia 7 Sep, 17 at 6:34 am - Reply

      You’re welcome.

  4. Andrew Evans 6 Sep, 17 at 2:40 pm - Reply

    To keep within Windows Rules something a formula like
    would be useful

    • Puneet Gogia 7 Sep, 17 at 6:34 am - Reply

      Thanks for sharing, Andrew.

  5. Sorinola Oladapo A 12 Mar, 17 at 7:26 am - Reply

    Interesting piece. Please what if I want to generate 5 alphabets and the result to be in one single cell like “B, E, H, P, G”. Do I have to write the formula above and concatenate/ampersand them or is there a shorter and better means? Thank you

    • Puneet Gogia 19 Mar, 17 at 8:54 am - Reply

      You can use VBA for that. tell me If I can help.

      • Sorinola Oladapo A 19 Mar, 17 at 9:13 am - Reply

        Yes please, I will appreciate

    • YasserKhalil 19 Aug, 17 at 7:06 pm - Reply

      Hello. May be this is useful for you

  6. Kapil Marwaha 12 Mar, 17 at 6:37 am - Reply

    Awesome man, thank you !

    • Puneet Gogia 15 Mar, 17 at 8:36 am - Reply

      I so glad you liked it. 🙂

Leave A Comment