Gizmo's Freeware Forum help with letters
 FAQ Calendar Search Today's Posts Mark Forums Read

 10. Apr 2011, 02:19 AM #1 (permalink) Senior Member   Join Date: Aug 2009 Location: Milton Keynes Posts: 277 help with letters I need something that will help me make random combinations of letters and numbers. or a text file with all possible combinations. im looking for combinations ONLY 8 digits long, only in uppercase letters A-Z 0-9 I need to see combinations as a list not a password generator that only shows 1, or is there a password generatore that I can set for 8 digits and only uppercase that will show me a list? I know this is a strange request but the brains at gizmo are the best to ask, I just dont want to sit in front of a txt file doing the combinations myself __________________ If it ain't broke don't fix it, improve it, break it then fix it
 10. Apr 2011, 02:55 AM #2 (permalink) Maestro di Search     Join Date: Jul 2008 Posts: 7,825 It can be done in a spreadsheet with a simple formula, for example: Copy this into cell A1: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 Copy this formula into cell B1: =MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) Then copy B1 cell down the list as long as you want. Last edited by Jojoyee; 10. Apr 2011 at 03:06 AM.
 10. Apr 2011, 01:35 PM #3 (permalink) Senior Member   Join Date: Aug 2009 Location: Milton Keynes Posts: 277 I did think of spreadsheet but I havnt had any ecperience using it. I tried doing just uppercase letters at first A-Z I put them in A1 then I input the formula in B1 but if the = was there first it gave me error;508 if I take the = out I dont get a answer I just have the B collum full of the formula. I'l just focus on the letters for now, im using open office if it makes a difference, and will this show all the results for example start with AAAAAAAA, AAAAAAAB,AAAAAAAC, AAAAAAAD all the way to ZZZZZZZW ZZZZZZZX, ZZZZZZZY, ZZZZZZZZ? I imagine ths would be a huge text file. __________________ If it ain't broke don't fix it, improve it, break it then fix it
 10. Apr 2011, 02:41 PM #4 (permalink) Maestro di Search     Join Date: Jul 2008 Posts: 7,825 Error 508 is an error message for pair missing. Check if you have entered the formula correctly and make sure that RANDBETWEEN is one word without space in between. A formula must start with an equal sign, either you use a spreadsheet in OpenOffice or MSOffice. If you enter ABCDEFGHIJKLMNOPQRSTUVWXYZ into A1, then change the formula in B1 and cells below it to the following. =MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) & MID(\$A\$1,RANDBETWEEN(1,26),1) The outcome should be something like this. Since they're random numbers, they shouldn't be sequential. JMEHJQLY ZVBXYIUW LAFKGLIW IWMOTDTQ OIGPEUBJ IMFHFHCR HGVXZEMB RXLJVJJK SYDMIISO ZVVOFEGA AEPPOFXT EQAIZBFH ....
 10. Apr 2011, 05:14 PM #5 (permalink) Senior Member   Join Date: Aug 2009 Location: Milton Keynes Posts: 277 I got the formula right this time but it had its own problem, at the end of the formula it should have been a 8 for 8 digits as when I put 1 it only gave me 1 letter. but also its not choosing random letters its starting somewhere in the alphabet like efghijkl or mnopqrst not anything like goghujkl and it shows 3 single letters like xyz now and then or do I have to go into the few thousand rows befor I get to ones like hgyrklmj? is spreadsheet the only way to do this? __________________ If it ain't broke don't fix it, improve it, break it then fix it
11. Apr 2011, 02:55 AM   #6 (permalink)
Maestro di Search

Join Date: Jul 2008
Posts: 7,825

Quote:
 Originally Posted by systemcrash I got the formula right this time but it had its own problem, at the end of the formula it should have been a 8 for 8 digits as when I put 1 it only gave me 1 letter. but also its not choosing random letters its starting somewhere in the alphabet like efghijkl or mnopqrst not anything like goghujkl and it shows 3 single letters like xyz now and then or do I have to go into the few thousand rows befor I get to ones like hgyrklmj?

Quote:
 is spreadsheet the only way to do this?
Not the only way but it's an easy way I believe.

 11. Apr 2011, 08:31 PM #7 (permalink) Senior Member   Join Date: Aug 2009 Location: Milton Keynes Posts: 277 I used ; in place of , because if i use comma's then i get the error508 message so my formula was =MID (\$A\$1;RANDBETWEEN(1;26);8) everytime i copied the code =MID(\$A\$1,RANDBETWEEN(1,26),1) & i got the error508 i copied and paste the code given. I was looking into scripts that could this for me but i couldn't find the right one. Im not experienced in making scripts. There was one though that said the created txt file would be 1720GB! that's a massive amount just on a txt file if that calculation is right then i'll probably give it a miss trying to create this, I haven't got the room to store a txt file that size __________________ If it ain't broke don't fix it, improve it, break it then fix it
11. Apr 2011, 09:29 PM   #8 (permalink)
Senior Member

Join Date: Sep 2010
Location: Here.
Posts: 1,522

Quote:
 Originally Posted by Jojoyee It can be done in a spreadsheet with a simple formula, for example: Copy this into cell A1: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 Copy this formula into cell B1: =MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) & MID(\$A\$1,RANDBETWEEN(1,36),1) Then copy B1 cell down the list as long as you want.
This formula is working perfectly for me in MS Excel but is producing the Error508 message in OpenOffice.
__________________
Heavy Metal + Lego = . That is all. ^.^

 11. Apr 2011, 11:32 PM #9 (permalink) Senior Member   Join Date: Aug 2009 Location: Milton Keynes Posts: 277 I'l explain what it was for, I wanted a list of combinations that could be used for a sort of key pass system for a computer login. It was to make a list of codes that could be used as a password form 8 digits long a mix of letters and numbers. I suppose it would work 6 digits long but 8 just seemed better. A complete list wouldn't have any duplicates and a name could easily be put beside the taken password in a txt or spreadsheet document. And being a complete list the user could choose there own 8 digit password that the remember and using the find feature in the documents could easily see if the password was taken. But storing a 1720GB file is not a option. I only focused on A-Z until i got the hang of the formula or scipt creation then i would have added back in the numbers. But then i guess the file would grow further then 1720GB I defiantly need to learn how to use spreadsheet though __________________ If it ain't broke don't fix it, improve it, break it then fix it
12. Apr 2011, 02:44 AM   #10 (permalink)
Maestro di Search

Join Date: Jul 2008
Posts: 7,825

Quote:
 Originally Posted by garth This formula is working perfectly for me in MS Excel but is producing the Error508 message in OpenOffice.
I just copied the formula over in LibreOffice and it works fine. Recheck if the formula you copied over has any spaces which split the function names. If so, you need to remove them.

Not sure if ";" has to be used to replace "," in OpenOffice as reported by Systemcrash, since now I have only LibreOffice installed on my machine.

p.s. In LibreOffice, if I change "," to ";", it automatically change back to ",". Probably this is something different between this and OpenOffice. Can anyone verify this?

Last edited by Jojoyee; 12. Apr 2011 at 02:55 AM. Reason: added: p.s.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

All times are GMT +1. The time now is 05:57 AM.