combine set of letters randomly

R

rp

hi,

is it possible to combine 8 letters (for example) randomly, i mean to
generate different combinations from these 8 letters? please help

yob
 
R

Robert_Steel

This solution assumes repeat letters are not a problem.

the CHAR function will return a character from a number within a range
65-90 is A - Z
97-122 ia a-z

therefore if you use the ATP function
=CHAR(RANDBETWEEN(65,90))
you will get a single letter

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

Ugly but it does what it says.

hth RES
 
Top