| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having trouble with number series
I'm stuck on how to create a number series in Excel. For instance, I can put the following in these respective cells: A1 1 A2 2 A3 3 ....and then I can fill the series down to A10000. However, I actually need the numbers to be in the middle of some text. ie. A1 abc00000000001abc A2 abc00000000002abc A3 abc00000000003abc ....so I can fill down to A10000000000. I can't seem to do this. Is there a way that this can be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
