software

i need to generate these letters

aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column

What's best/easiest way?
In cells B1:B26 put A, in B27:B52 put B, etc etc through Z
In cells C1:C26 put the alphabet, a,b,c,d,etc etc..........then copy and
paste it down to C27:C52, etc etc till it fills by the Z's in column B
Then in A1 put =B1amp;C1 and copy down.........do Copy gt; PasteSpecial gt; Values
on column A and delete columns B and C.........

Vaya con Dios,
Chuck, CABGx3quot;JethroUK©quot; gt; wrote in message
news
gt; i need to generate these letters
gt;
gt; aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt;
gt; What's best/easiest way?
gt;
gt;
Try this:

A1: =CHAR(FLOOR((ROW()-1)/26,1) 97)amp;CHAR(MOD(ROW()-1,26) 97)
Copy down

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXPquot;JethroUK©quot; wrote:

gt; i need to generate these letters
gt;
gt; aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt;
gt; What's best/easiest way?
gt;
gt;
gt;

On more, put this in A1 and drag down:
=CHAR(INT((ROW(A1)-1)/26) 97)amp;CHAR(MOD(ROW(A1)-1,26) 97)

If you really mean upper case, change the 97's to 65's:
=CHAR(INT((ROW(A1)-1)/26) 65)amp;CHAR(MOD(ROW(A1)-1,26) 65)
quot;JethroUK©quot; wrote:
gt;
gt; i need to generate these letters
gt;
gt; aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt;
gt; What's best/easiest way?

--

Dave Peterson

On Mon, 15 May 2006 00:32:20 GMT, quot;JethroUK©quot; gt; wrote:

gt;i need to generate these letters
gt;
gt;aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt;
gt;What's best/easiest way?
gt;

A1:=CHAR(97 (ROW()-1)/26)amp;CHAR(97 MOD(ROW()-1,26))

Fill down to A676--ron

If you're going to do this on many different occasions, it might pay to
create a quot;Custom Listquot;, so that each time you need to make this list, you
could simply enter quot;AAquot; and *autofill* down a column or across a row.

Start with a new sheet, and enter this formula in A1:

=IF(ROW(A1) gt; 26, CHAR(INT((ROW(A1) - 1)/ 26) 64) amp; CHAR(MOD(ROW(A1) -
1,26) 65), CHAR(ROW(A1) 64))

You can copy it down to A650 to end up with quot;XZquot;.

Now, while the column is *still* selected from the copy, let's remove the
formulas.
Right click in the selection and choose quot;Copyquot;.
Right click again and choose quot;Paste Specialquot;,
And click on quot;Valuesquot;, then lt;OKgt;.

And NOW, while the column is *still* selected from the formula removal,
Click on:
lt;Toolsgt; lt;Optionsgt; lt;CustomListsgt;
The quot;ImportListquot; box should already have the column range entered, since it
was selected.
Click on quot;Importquot;, then lt;OKgt;.

Strangely enough, whatever case you start your list with (AA, BB - aa, bb),
XL will continue to autofill with *that* case.

Another advantage of custom lists is, you can start anywhere in the middle,
and XL will take it up from wherever you started.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;JethroUK©quot; gt; wrote in message
news
gt; i need to generate these letters
gt;
gt; aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt;
gt; What's best/easiest way?
gt;
gt;Peachy - thanks very much - i forgot about CHAR() func - i used to be able
to figure stuff out myself once upon a time )

quot;Ron Coderrequot; gt; wrote in message
...
gt; Try this:
gt;
gt; A1: =CHAR(FLOOR((ROW()-1)/26,1) 97)amp;CHAR(MOD(ROW()-1,26) 97)
gt; Copy down
gt;
gt; Is that something you can work with?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;JethroUK©quot; wrote:
gt;
gt; gt; i need to generate these letters
gt; gt;
gt; gt; aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
gt; gt;
gt; gt; What's best/easiest way?
gt; gt;
gt; gt;
gt; gt;