Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need solution to formula problem | Excel Discussion (Misc queries) | |||
problem with formula | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
Precision problem with automated formula fill-in | Excel Worksheet Functions | |||
How do I copy a result without copying the formula? | Excel Discussion (Misc queries) |