| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Invisable text in formula bar | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Concatenate text and numbers? | Excel Worksheet Functions | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Linear Mode
