Wrong result displayed when using concatenate???

[bhatbu]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi,
I am trying to concatenate two columns of data, in the formula builder it calculates the correct result and will display the correct result in the worksheet for the first row, however when I click the fill handle to copy the formula down the column it copies the result from the first row. The formula is correct in the formula bar, however the results is the same all the way down the column. Also, in the formula builder toolbox, it displays the correct result but it is not showing up in the worksheet? Any ideas???
Thanks

 

[macropod]

Hi,

Try removing an '$' symbols in the row references in your formula before copying/filling down. For example, change =$A$1&$B$1 to
=$A1&$B1 (Note: this gives the same result as changing =CONCATENATE($A$1,$B$1) to =CONCATENATE($A1,$B1).

 

[JE McGimpsey]

Try removing an '$' symbols in the row references in your formula before
copying/filling down. For example, change =$A$1&$B$1 to
=$A1&$B1 (Note: this gives the same result as changing
=CONCATENATE($A$1,$B$1) to =CONCATENATE($A1,$B1).

You can find out more about why this works in the "Switch between
relative and absolute references" topic in XL08 Help.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi,
I am trying to concatenate two columns of data, in the formula builder it
calculates the correct result and will display the correct result in the
worksheet for the first row, however when I click the fill handle to copy the
formula down the column it copies the result from the first row. The formula
is correct in the formula bar, however the results is the same all the way
down the column. Also, in the formula builder toolbox, it displays the correct
result but it is not showing up in the worksheet? Any ideas???
Thanks

Also check to make sure you have calculation set to Automatic. Press F9
after you have filled the column to see if this helps.

 

[bhatbu]

Hi
Thanks for all the responses. I did not have a '$' symbol in the reference formula and copying/filling down was still not working correctly. However, I did have the calculations preference set to manual instead of automatic, so changing that to automatic fixed the problem!
Thanks again!