Thanks Gord Dibben for your prompt and helpful response.
"Gord Dibben" wrote:
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.
|