You did not copy the example correctly.

=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")

Note: no double quotes around cell references.


Gord Dibben MS Excel MVP

On Sat, 8 Dec 2007 11:47:18 -0500, "Jeff" wrote:

Thank you. That did it. (I was copying the example in the "Excel Help")