how to fill a different series?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I tried this but it doesn't work



MarkN said:
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
Click to expand...
 
Yes it does, send me an email address and I'll send you a working example
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to complete a specific series? 2
How to fill cells with a different kind of series? 1
Automatic Cut & Paste - Possible? 1
ambiguous outer joins 3
Ambiguous outer joins 1
Series fill only copying and fill series greyed out 1
return results based on multiple conditions 3
Fill Series 1

Back
Top