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?

how to fill a different series?
 

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?

how to fill a different series?
 

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?

how to fill a different series?
 

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?

how to fill a different series?
 

email:



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?

how to fill a different series?
 

The file has been sent
--
Thanks,
MarkN


"Jared" wrote:

email:



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?

how to fill a different series?
 

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" wrote in message
...
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?

how to fill a different series?
 

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 EditCopy
Then, EditPaste SpecialValuesOK

Biff

"Jared" wrote in message
...
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?