Problem copying formula.
 

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)

How are you copying? If you drag the small square at the bottom-right of the
selected cell, you can copy the cell. It should change the values to the
correct row as you copy this way. So just drag that square down the 3000
rows you need.

"Robin Gray" wrote:

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)

Hi Robin-

Press the F9 key & see if the copied formulas update. If they do, take a
look at ToolsOptions--Calculate and check the box for Automatic.

HTH |:)

"Robin Gray" wrote:

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)