ExcelBanter - Formula for Incrementing text & numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for Incrementing text & numbers (https://www.excelbanter.com/excel-discussion-misc-queries/62152-formula-incrementing-text-numbers.html)

KeliB

Formula for Incrementing text & numbers

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

Ron Coderre

Formula for Incrementing text & numbers

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

"KeliB" wrote:

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

KeliB

Formula for Incrementing text & numbers

Woo hooo!!! That is EXACTLY what I want! Many thanks, Ron. :)

"Ron Coderre" wrote:

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

"KeliB" wrote:

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

All times are GMT +1. The time now is 12:55 PM.