help with letters

[systemcrash]

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

[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.

[systemcrash]

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.

[Jojoyee]

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
....

[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? is spreadsheet the only way to do this?

[Jojoyee]

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?

Please paste your formula here and let's see how it works.

is spreadsheet the only way to do this?

Not the only way but it's an easy way I believe.

[systemcrash]

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

[garth]

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.

[systemcrash]

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

[Jojoyee]

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?