Thread: how to complete a specific series?

if my series is a2b, a3b, a4b, a5b how do i use excel to fill the rest a6b
a7b and not repeat a2b a3b

thanks
jared

Hi Jared

Try
="a"&ROW(2:2)&"b"
and copy down.
If you want to "fix" the data, copy the resulting column, and
Paste>Special>Values

--
Regards

Roger Govier


"Jared" <Jared@discussions.microsoft.com> wrote in message
news:A7AB389D-DE75-4EB0-BC2C-C2F735D6BF37@microsoft.com...
> if my series is a2b, a3b, a4b, a5b how do i use excel to fill the rest
> a6b
> a7b and not repeat a2b a3b
>
> thanks
> jared

It works wonderful. But now i have another question:
this information has to be filled out but there are spaces in between:

example: a1 = a2b
a4 = a3b
a7 = a4b

how do i do it now?

and another question:
how do i copy cells a1 a4 a7 and paste it so the gaps still exist but
without copying the blanks cells.

thanks again,

jared



"Roger Govier" wrote:

> Hi Jared
>
> Try
> ="a"&ROW(2:2)&"b"
> and copy down.
> If you want to "fix" the data, copy the resulting column, and
> Paste>Special>Values
>
> --
> Regards
>
> Roger Govier
>
>
> "Jared" <Jared@discussions.microsoft.com> wrote in message
> news:A7AB389D-DE75-4EB0-BC2C-C2F735D6BF37@microsoft.com...
> > if my series is a2b, a3b, a4b, a5b how do i use excel to fill the rest
> > a6b
> > a7b and not repeat a2b a3b
> >
> > thanks
> > jared
>
>
>