software

Hello,
This is what I want to accomplish:
1AAw.....9AAW, 1ABW.....
W must remain at the end
Any help would be greatly appreciated!!!

Try this:

A1:
=(MOD(ROW()-1,9) 1)amp;CHAR(MOD(FLOOR((ROW()-1)/(26*9),1),26) 65)amp;CHAR(MOD(FLOOR((ROW()-1)/9,1),26) 65)amp;quot;Wquot;

Copy that formula down as far as you need.

Is that what you're looking to do?

***********
Regards,
Ron

XL2002, WinXP-Proquot;KeliBquot; wrote:

gt; Hello,
gt; This is what I want to accomplish:
gt; 1AAw.....9AAW, 1ABW.....
gt; W must remain at the end
gt; Any help would be greatly appreciated!!!

Woo hooo!!! That is EXACTLY what I want! Many thanks, Ron. quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; A1:
gt; =(MOD(ROW()-1,9) 1)amp;CHAR(MOD(FLOOR((ROW()-1)/(26*9),1),26) 65)amp;CHAR(MOD(FLOOR((ROW()-1)/9,1),26) 65)amp;quot;Wquot;
gt;
gt; Copy that formula down as far as you need.
gt;
gt; Is that what you're looking to do?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;KeliBquot; wrote:
gt;
gt; gt; Hello,
gt; gt; This is what I want to accomplish:
gt; gt; 1AAw.....9AAW, 1ABW.....
gt; gt; W must remain at the end
gt; gt; Any help would be greatly appreciated!!!