Excel copy and pasting?!
Question:
Okay I have a math assignment and it involves repetitiveness and I've been using excel. how can i do this faster.? the problem is: so and so has a password, the first three characters are letters and the last 2 are numbers. list all the possible passwords.
so how i've been doing it is aaa01 and clicking and dragging so it goes to aaa99. but the problem is that i cant just click and drag the letters to make it go aaa01 to aab01. i have to type in each one individually. another method i've tried is typing aa, dragging down 26 slots down, and then copy and past the letters that i have in a separate column. its not working because when i try to paste the letters it deletes what i already have in the column. help please.?Q&A For PC
so how i've been doing it is aaa01 and clicking and dragging so it goes to aaa99. but the problem is that i cant just click and drag the letters to make it go aaa01 to aab01. i have to type in each one individually. another method i've tried is typing aa, dragging down 26 slots down, and then copy and past the letters that i have in a separate column. its not working because when i try to paste the letters it deletes what i already have in the column. help please.?Q&A For PC
Answers:
Put this formula to a cell in Row 1, say A1, copy it downward, it should show all possible passwords
=CHAR(97 +MOD(INT(ROW( )/(26*26*10*10)), 26*26*26))&CHAR(97 +MOD(INT(ROW( )/(26*10*10)), 26*26))&CHAR(97 +MOD(INT(ROW( )/(10*10)), 26))&REPT(0,2-LEN(MOD(ROW( ),100)))&MOD(ROW( ),100)
or its simplified version
=CHAR(97 +MOD(INT(ROW( )/(67600)), 17576))&CHAR(97 +MOD(INT(ROW( )/(2600)), 676))&CHAR(97 +MOD(INT(ROW( )/(100)), 26))&REPT(0,2-LEN(MOD(ROW( ),100)))&MOD(ROW( ),100)
If you want to list it by VBA here's the code http://www.freewebs.com/swhtam/YA/aaa00p... , On excel by Alt+F11, to go to vb editor, right click on the left side icon, then insert a module to the workbook, double click the module, and on the right blank area add the code
Go back to worksheet, Alt+F8 and choose the line aaa00pwd then click run button to run the code. The list will start from Cell A1 of the active sheet
Please contact for more infoQ&A For PC
=CHAR(97 +MOD(INT(ROW( )/(26*26*10*10)), 26*26*26))&CHAR(97 +MOD(INT(ROW( )/(26*10*10)), 26*26))&CHAR(97 +MOD(INT(ROW( )/(10*10)), 26))&REPT(0,2-LEN(MOD(ROW( ),100)))&MOD(ROW( ),100)
or its simplified version
=CHAR(97 +MOD(INT(ROW( )/(67600)), 17576))&CHAR(97 +MOD(INT(ROW( )/(2600)), 676))&CHAR(97 +MOD(INT(ROW( )/(100)), 26))&REPT(0,2-LEN(MOD(ROW( ),100)))&MOD(ROW( ),100)
If you want to list it by VBA here's the code http://www.freewebs.com/swhtam/YA/aaa00p... , On excel by Alt+F11, to go to vb editor, right click on the left side icon, then insert a module to the workbook, double click the module, and on the right blank area add the code
Go back to worksheet, Alt+F8 and choose the line aaa00pwd then click run button to run the code. The list will start from Cell A1 of the active sheet
Please contact for more infoQ&A For PC