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)