generate random 2alphabet

[sr_88]

Dear Mr Suhu, Guru, teacher, excel freak,

how to generate 2random alphabet

example :
df
qw
ty
qw
yw
qw
tw

what is the formula ? like randbetween(0,99) , but mine is for alphabet,

thx

[dilipandey]

Hi sr_88,

I would suggest you to type in 1,2,3 to 26 in column A and type a,b,c to z in column B and use below formula:-

=VLOOKUP(RANDBETWEEN(1,26),$A:$B,2,0)&VLOOKUP(RANDBETWEEN(1,26),$A:$B,2,0)

See attached:- random alphabets.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[BB1972]

sr_88,

You could also use the following:

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

Paste this into an empty cell, and it will return 2 random letters, without the need to type letters A-Z & 1-26 elsewhere.


EDIT: if you require lower-case letters, change the "65,90" in the formula to "97,122".

[dilipandey]

I liked it Brendan..

Sr_88... since you are wish to have small (lower caps) alphabet letters..
use randbetween (97,122) in Brendan's formula.. else you'll need to user Lower function..cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[sr_88]

THX for the quick reply Mr dilipandey and Mr Brendan,
why my excel
=randbetween(97,122) outcome #name?

[dilipandey]

Hi sr_88,

May be you need to install ATP add - in.

Press Alt + t + i and check the checkboxes against Analysis Tool pack option... and try again.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[sr_88]

Thx dilipandey , it works

[dilipandey]

you are welcome... cheers



Regards,
DILIPandey
<click on below * if this helps>