Excel Guru's need help with a formula/algorithm ?
#1
Excel Guru's need help with a formula/algorithm ?
ok anybody help,
need an excel formula that will allow me to randomly generate a password that has
2 alpha and 4 numeric and say for 50 users
eg
ab9234
thanks in advance hopefully
jase
need an excel formula that will allow me to randomly generate a password that has
2 alpha and 4 numeric and say for 50 users
eg
ab9234
thanks in advance hopefully
jase
#2
=CHAR(65+INT(RAND()*26)) & CHAR(65+INT(RAND()*26)) & CHAR(48+INT(RAND()*10)) & CHAR(48+INT(RAND()*10)) & CHAR(48+INT(RAND()*10)) & CHAR(48+INT(RAND()*10))
add 97 instead of 65 for lower case letters
add 97 instead of 65 for lower case letters
#3
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
generate a random number (inline wish the ascii code's)
then convert the random number using chr()
David
then convert the random number using chr()
David
#5
#7
Scooby Regular
Join Date: Dec 2005
Location: West Yorkshire
Posts: 4,778
Likes: 0
Received 0 Likes
on
0 Posts
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM