Unable to copy the merged cell to the rest of the column

[Guest]

Using the formula =CONCATENATE(B369,": ",C369) in cell D369, I'm able to
merge the text in the referenced cells. However, using the instruction
provided in Excel help and the demo video on Excel support site I'm unable to
extend the concetenation to the remainder of the column.
All that appears in the succeding cells is the same text as the originally
merged cell. Interestingly if one checks the formulas in the newly propagated
cells its is =CONCATENATE(B370,": ",C370); =CONCATENATE(B371,": ",C371);
=CONCATENATE(B372,": ",C372); etc. but the text is the same as the orginal
text that was expanded to the remainder of the column.

I'm running Excel 2003 with ALL updates installed on the final release of
Vista. I've also duplicated the problem on another installation of Excel
running on XP with ALL updates.


Redrx

 

[JE McGimpsey]

Try choosing Tools/Options/Calculation and select Automatic.

 

[T. Valko]

It sounds like calculation is set to manual. Check that calculation is set
to AUTOMATIC.

Tools>Options>Calculation

Another way to write your formula:

=B369&": "&C369

Biff

 

[Stan Brown]

Sat, 21 Apr 2007 11:10:03 -0700 from redrxturbo

Interestingly if one checks the formulas in the newly propagated
cells its is =CONCATENATE(B370,": ",C370); =CONCATENATE(B371,": ",C371);
=CONCATENATE(B372,": ",C372); etc. but the text is the same as the orginal

I'll bet you've got calculation set to Manual.

Tools | Options | Calculation.