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?

Having trouble with number series
 

Have you tried having the Number in Col A and Text in Col B and then
using Concatenate.

E.g enter A1&B1 in C1

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561779

Having trouble with number series
 

try put in A1 and copy down

="abc"&TEXT(ROW(),"00000000000")&"abc"




"Cuzman" skrev:


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?

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?

Having trouble with number series
 

Cuzman

The numbers must be entered as text in the column to begin with.

In B1 enter '000001 and in B2 enter '000002

Drag/copy down to A10000(not to A10000000)

Then do the =A1&B1&C1

Or as Sandy' s formula if you prefer.


Gord Dibben MS Excel MVP

On Sat, 15 Jul 2006 23:02:39 +0100, "Sandy Mann"
wrote:

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?

Having trouble with number series
 

excelent wrote:

* try put in A1 and copy down

="abc"&TEXT(ROW(),"00000000000")&"abc" *


Thanks to everyone who helped. The above suggestion worked perfectly.