Gene

="Avg: " & AVERAGE(A1:A10)


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 10:29:02 -0700, Gene wrote:

I would like to have a mixed cell format in a single cell, i.e., a label
followed by the results of a formula calculated in the cell. An example
would be: "Avg.: " (the result from a formula calculation). How can I do
this? Thanks.