6SJ,
I like your approach, but it preferentially chooses numbers (one of 10 symbols half the time) versus letters (26 symbols the other half of the time).
An alternative for RANC:
=CHAR(IF(RANDBETWEEN(1,36)<11, RANDBETWEEN(48,57), RANDBETWEEN(65,90)))
EDIT: Or
=MID("0123456789ABCDEFGHIJKLMONPQRSTUVWXYZ", RANDBETWEEN(1,36), 1)
Last edited by shg; 07-25-2013 at 01:21 PM.
Entia non sunt multiplicanda sine necessitate
shg, delightful! Thanks for pointing that out.
There are currently 2 users browsing this thread. (0 members and 2 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks