help with array formula

[pluribus]

Hi

I have a formula which generates every combination of letters between a and zzz. This is below:

=IF(ROW(A1)<=(26^3),CHAR(65+INT((ROW(A1)-1)/26^2))&CHAR(65+MOD(INT((ROW(A1)-1)/26),26))&CHAR(65+MOD(ROW(A1)-1,26)),"")

What I now need to do is adjust the formula so that it includes the numbers 1 to 999.

I want to end up with a list of alphanumerics from a to zzz999.

I know this will take ages to do and its simply to generate a brute force list to test my home server security. I just dont want to type it all out as I dont have a spare couple of months...

If anyone can help I would really appreciate it.

Cheers

Ian

 

[GlennUK]

Does this do what you want? :

=IF(ROW(A1)<=((26^3)*999),CHAR(65+INT((MOD(ROW(A1),26^3))/26^2))&CHAR(65+MOD(INT((ROW(A1)-1)/26),26))&CHAR(65+MOD(ROW(A1)-1,26))&ROUNDUP(ROW(A1)/26^3,0),"")

 

[pluribus]

Does this do what you want? :

=IF(ROW(A1)<=((26^3)*999),CHAR(65+INT((MOD(ROW(A1),26^3))/26^2))&CHAR(65+MOD(INT((ROW(A1)-1)/26),26))&CHAR(65+MOD(ROW(A1)-1,26))&ROUNDUP(ROW(A1)/26^3,0),"")

Thanks Glenn, did the job perfectly!

 

[GlennUK]

That's great!