how to fill a different series?

i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
rest a6b a7b a8b and so on and not a2b again a3b


thanks?

Hi Jared,

Create a custom format "a"0"b" , you can then enter just number 2 in
first cell, 3 in second cell and drag it to fill
--
Hope this helps,
MarkN


"Jared" wrote:

> i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
> rest a6b a7b a8b and so on and not a2b again a3b
>
>
> thanks?

I tried this but it doesn't work



"MarkN" wrote:

> Hi Jared,
>
> Create a custom format "a"0"b" , you can then enter just number 2 in
> first cell, 3 in second cell and drag it to fill
> --
> Hope this helps,
> MarkN
>
>
> "Jared" wrote:
>
> > i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
> > rest a6b a7b a8b and so on and not a2b again a3b
> >
> >
> > thanks?

Yes it does, send me an email address and I'll send you a working example
--
Thanks,
MarkN


"Jared" wrote:

> I tried this but it doesn't work
>
>
>
> "MarkN" wrote:
>
> > Hi Jared,
> >
> > Create a custom format "a"0"b" , you can then enter just number 2 in
> > first cell, 3 in second cell and drag it to fill
> > --
> > Hope this helps,
> > MarkN
> >
> >
> > "Jared" wrote:
> >
> > > i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
> > > rest a6b a7b a8b and so on and not a2b again a3b
> > >
> > >
> > > thanks?

email: harelj@hotmail.com



thanks,
jared




"MarkN" wrote:

> Yes it does, send me an email address and I'll send you a working example
> --
> Thanks,
> MarkN
>
>
> "Jared" wrote:
>
> > I tried this but it doesn't work
> >
> >
> >
> > "MarkN" wrote:
> >
> > > Hi Jared,
> > >
> > > Create a custom format "a"0"b" , you can then enter just number 2 in
> > > first cell, 3 in second cell and drag it to fill
> > > --
> > > Hope this helps,
> > > MarkN
> > >
> > >
> > > "Jared" wrote:
> > >
> > > > i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
> > > > rest a6b a7b a8b and so on and not a2b again a3b
> > > >
> > > >
> > > > thanks?

The file has been sent
--
Thanks,
MarkN


"Jared" wrote:

> email: harelj@hotmail.com
>
>
>
> thanks,
> jared
>
>
>
>
> "MarkN" wrote:
>
> > Yes it does, send me an email address and I'll send you a working example
> > --
> > Thanks,
> > MarkN
> >
> >
> > "Jared" wrote:
> >
> > > I tried this but it doesn't work
> > >
> > >
> > >
> > > "MarkN" wrote:
> > >
> > > > Hi Jared,
> > > >
> > > > Create a custom format "a"0"b" , you can then enter just number 2 in
> > > > first cell, 3 in second cell and drag it to fill
> > > > --
> > > > Hope this helps,
> > > > MarkN
> > > >
> > > >
> > > > "Jared" wrote:
> > > >
> > > > > i have a series. a2b a3b a4b a5b how do i use a fill function to fill out the
> > > > > rest a6b a7b a8b and so on and not a2b again a3b
> > > > >
> > > > >
> > > > > thanks?

It works but the true underlying value of the cell is the number and not the
entire string:

a2b = true value is 2, not a2b.

Biff

"MarkN" <MarkN@discussions.microsoft.com> wrote in message
news:A49A85E8-BABD-4667-A424-E24A65F7DF35@microsoft.com...
> Yes it does, send me an email address and I'll send you a working example
> --
> Thanks,
> MarkN
>
>
> "Jared" wrote:
>
>> I tried this but it doesn't work
>>
>>
>>
>> "MarkN" wrote:
>>
>> > Hi Jared,
>> >
>> > Create a custom format "a"0"b" , you can then enter just number 2
>> > in
>> > first cell, 3 in second cell and drag it to fill
>> > --
>> > Hope this helps,
>> > MarkN
>> >
>> >
>> > "Jared" wrote:
>> >
>> > > i have a series. a2b a3b a4b a5b how do i use a fill function to fill
>> > > out the
>> > > rest a6b a7b a8b and so on and not a2b again a3b
>> > >
>> > >
>> > > thanks?

Hi!

One way:

If you're filling down:

="a"&ROW(A2)&"b"

If you're filling across:

="a"&COLUMN(B2)&"b"

Then you can convert the formulas to constants by:

Selecting the range of formulas.
Goto Edit>Copy
Then, Edit>Paste Special>Values>OK

Biff

"Jared" <Jared@discussions.microsoft.com> wrote in message
news:B5AB093E-0A06-4AB0-B34D-43470F7E7651@microsoft.com...
>i have a series. a2b a3b a4b a5b how do i use a fill function to fill out
>the
> rest a6b a7b a8b and so on and not a2b again a3b
>
>
> thanks?