This should be simple But ....
In column A is the house Number, In column B is the street.
In C1 I have =concatenate(A1," ",B1) - this puts the House number and
street in C1 with a space between them. OK.
I now need to copy this down 3000 rows but when I copy the cell C1 to C2 I
get exactly the same formula in C2.
I expected it to change to =concatenate(A2," ",B2)
This must be finger trouble but it is driving me MAD!
Any suggestions.
TIA
Bob (rapidly loosing the few hairs left)

"Robin Gray" wrote in
:

I now need to copy this down 3000 rows but when I copy the cell C1 to
C2 I get exactly the same formula in C2.
I expected it to change to =concatenate(A2," ",B2)


When you select C1 you'll see a tiny square at the bottom right corner.
Drag that down to copy the formula.

Did it work?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

"Dodo" wrote in message
. ..
"Robin Gray" wrote in
:

I now need to copy this down 3000 rows but when I copy the cell C1 to
C2 I get exactly the same formula in C2.
I expected it to change to =concatenate(A2," ",B2)


When you select C1 you'll see a tiny square at the bottom right corner.
Drag that down to copy the formula.

Did it work?

Just realised that it was copying the formula correctly but the result
displayed was the same as in C1. Pressing F9 to get it to recalulate has
sorted it! Kinda wierd but sorted.

Thanks for the reply anyway

Bob

Robin

Not all that weird if you know how Excel determines calculation mode.

ToolsOptionsCalculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 16:44:05 +0000 (UTC), "Robin Gray"
wrote:


"Dodo" wrote in message
...
"Robin Gray" wrote in
:

I now need to copy this down 3000 rows but when I copy the cell C1 to
C2 I get exactly the same formula in C2.
I expected it to change to =concatenate(A2," ",B2)


When you select C1 you'll see a tiny square at the bottom right corner.
Drag that down to copy the formula.

Did it work?

Just realised that it was copying the formula correctly but the result
displayed was the same as in C1. Pressing F9 to get it to recalulate has
sorted it! Kinda wierd but sorted.

Thanks for the reply anyway

Bob