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:



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:



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" 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?

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?