Thread
:
Having trouble with number series
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Having trouble with number series
A klunky workaround:
Use a helper column with the numbers filled down, then in the column you
want to fill with:
="abc"&B1&"abc"
then copy and Paste Special back into the same column and then finally
delete the helper column
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Cuzman" wrote in message
...
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann