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: 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 Depending on how many characters do you want to generate in a cell, add those many & =CHAR(RANDBETWEEN(65,90)). It[…]