• 1st June 2012, 10:46 AM
reggiep
I am trying to copy excel cells like this
Code:

```=c5 =c15 =c25```
Hard to explain but I have about 400 cells to fill and I can fill series as it jumps in just one step at a time.
To make things more complicated I'm actually doing this in google docs!

Thanks
• 1st June 2012, 11:00 AM
plexer
Do you mean you can't fill series?

What step jump are you looking for as in Office 2010 you can set that I know you said you were doing it in google.

Ben
• 1st June 2012, 11:09 AM
reggiep
Sorry, I am finding it hard to explain what I want to do here!

What I am trying to do is this...

=concatenate(A503," ",B503) | =C505 | =E505
=concatenate(A537," ",B537) | =C539 | =E539
=concatenate(A571," ",B571) | =C573 | =E573

And on and on!
• 1st June 2012, 11:17 AM
Flakes
im confused just use the concatenate?

dont think i know what you want, say you have these cells:

...A..B...C..D
1..c..h...2..9
2..e..f...u...h
3..5..j...t....6

what would you want as the result?

do you mean you want to lock the co-ords in the concatenation?

=concatenate(\$A\$571\$," ",\$B\$571\$) | =C573 | =E573
• 1st June 2012, 11:24 AM
reggiep
See I told you I was finding it hard!
I already have that in the six cells shown in my rubbish diagram but I now want to copy those down below stepping in steps of 34. When I try to fill series this doesn't carry on the steps of adding 34!
• 1st June 2012, 12:06 PM
DaveP
If you select the cells where you have already entered the formula. You will see a small black box at the bottom right of the selection range [see attached picture]

Click and drag this box out until you have populated the cells you want to have the copied formulas with the required values.

Job done.
• 1st June 2012, 12:13 PM
reggiep
Quote:

Originally Posted by DaveP
If you select the cells where you have already entered the formula. You will see a small black box at the bottom right of the selection range [see attached picture]

Click and drag this box out until you have populated the cells you want to have the copied formulas with the required values.

Job done.

That won't work for me! I think it is because it is a formula. If I just had
Quote:

a503
a537
a571
I could do as you suggest and it works fine. but the minute it becomes a formula that doesn't happen!
• 1st June 2012, 12:19 PM
reggiep
Got it. I take out the equals sign. Then fill series and then do a replace to put the equals sign back in!
• 1st June 2012, 12:19 PM
DaveP
Quote:

Originally Posted by reggiep
That won't work for me! I think it is because it is a formula. If I just had

I could do as you suggest and it works fine. but the minute it becomes a formula that doesn't happen!

How odd!. I have just used your formula [in one column only] and copied the values down with the following result [see attached]

Attachment 14163

Does this not work for you?
• 1st June 2012, 12:33 PM
enjay
I think that if you manually enter the first few rows, then highlight all of them and copy the formula down, Excel will carry on your +34 pattern. Might be wrong though...