I have a range of cells into which I need to enter an eight character
reference number. The number is made of of four alpha characters
followed by four numerical ones - BETA1010, BETA1011, BETA1012 etc.

Is there any way at all that I can enter BETA into all of the cells
first, then put BETA1010 in the first cell, highlight down and then fill
in series automatically BETA1011, BETA1012 etc. choosing the increment
value as I wish?

TIA

--
EMail address is disposable and never checked.
Outgoing message is certified VIRUS FREE by
*me* using nothing more than common sense.

Hi

I just did this with BETA1010 in a cell and filling it down (using Excel 2K)
without the need for separate steps. What version are you using? Try filling
down with the CTRL key held if it doesn't work without.

Hope this helps.
Andy.


"Paul Blarmy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a range of cells into which I need to enter an eight character
> reference number. The number is made of of four alpha characters
> followed by four numerical ones - BETA1010, BETA1011, BETA1012 etc.
>
> Is there any way at all that I can enter BETA into all of the cells
> first, then put BETA1010 in the first cell, highlight down and then fill
> in series automatically BETA1011, BETA1012 etc. choosing the increment
> value as I wish?
>
> TIA
>
> --
> EMail address is disposable and never checked.
> Outgoing message is certified VIRUS FREE by
> *me* using nothing more than common sense.

You can fill a series with alpha-numeric characters, as long as the numeric
is at the end.

However, you asked about choosing an increment.
To accomplish this, you must fill the first 2 cells manually, where the
second cell sets the size of the increment.

In cases where you wish to have the string end in an alpha, you can
increment the numeric by inserting a space between the numeric and the
alpha.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Paul Blarmy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I have a range of cells into which I need to enter an eight character
reference number. The number is made of of four alpha characters
followed by four numerical ones - BETA1010, BETA1011, BETA1012 etc.

Is there any way at all that I can enter BETA into all of the cells
first, then put BETA1010 in the first cell, highlight down and then fill
in series automatically BETA1011, BETA1012 etc. choosing the increment
value as I wish?

TIA

--
EMail address is disposable and never checked.
Outgoing message is certified VIRUS FREE by
*me* using nothing more than common sense.

On Thu, 8 Dec 2005 07:56:51 -0800, RagDyeR wrote...

> However, you asked about choosing an increment.
> To accomplish this, you must fill the first 2 cells manually, where the
> second cell sets the size of the increment.

And then on to FILL/SERIES/AUTOFILL

Brilliant! Thanks for the guidance :-)


--
EMail address is disposable and never checked.
Outgoing message is certified VIRUS FREE by
*me* using nothing more than common sense.

On Thu, 8 Dec 2005 14:33:01 -0000, wrote...

> I just did this with BETA1010 in a cell and filling it down (using Excel 2K)
> without the need for separate steps. What version are you using? Try filling
> down with the CTRL key held if it doesn't work without.

Seems I wasn't using AUTOFILL.

Thanks for the reply.

--
EMail address is disposable and never checked.
Outgoing message is certified VIRUS FREE by
*me* using nothing more than common sense.