How to generate random character strings using formulae in Excel?

While searching on net, I got this as the best solution for generating random character strings, follow below steps:

  1. As =RANDBETWEEN(10,50) gives random number between 10 and 50 try using =CHAR(RANDBETWEEN(65,90)) command, this will generate a uppercase alphabet randomly
  2. Depending on how many characters do you want to generate in a cell, add those many & =CHAR(RANDBETWEEN(65,90)). It will generate your strings randomly.

Ex: – I have tried creating random words of 4 letters, then I have used:



Leave a Reply

Your email address will not be published. Required fields are marked *