View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Thanks Gord Dibben for your prompt and helpful response.

Thanks for the feedback Gene.

Gord

On Tue, 25 Jul 2006 18:38:01 -0700, Gene wrote:



"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.




Gord Dibben MS Excel MVP