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

Try choosing Tools/Options/Calculation and select Automatic.

In article ,
redrxturbo wrote:

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

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

ToolsOptionsCalculation

Another way to write your formula:

=B369&": "&C369

Biff

"redrxturbo" wrote in message
...
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

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/