View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cuzman Cuzman is offline
external usenet poster
 
Posts: 2
Default 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?