Formula for Incrementing text & numbers

K

KeliB

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

Ron Coderre

Try this:

A1:
=(MOD(ROW()-1,9)+1)&CHAR(MOD(FLOOR((ROW()-1)/(26*9),1),26)+65)&CHAR(MOD(FLOOR((ROW()-1)/9,1),26)+65)&"W"

Copy that formula down as far as you need.

Is that what you're looking to do?

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

XL2002, WinXP-Pro
 
Top