jeudi 2 janvier 2020

How to generate a random string RANDBETWEEN

Hi I'm using this formula to generate a random code:

=RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,9))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,9))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))

In stead of somthing that looks like this: 6Ib&4Rj/

I get the NAME? error

Anybody can see where I'm missing something?




Aucun commentaire:

Enregistrer un commentaire