Text & formula in same cell
That worked great, is there anyway to format the number to 1 decimal place?
The average is really long!
"Gord Dibben" wrote:
="ABS" & Core!D55
Gord Dibben MS Excel MVP
On Wed, 5 Dec 2007 17:33:02 -0800, Raza wrote:
How do you mix text and formulas??
I want the cell C46 to have the text 'ABS' and the the formula '=Core!D55'
to the right.
Since the formula is just a reference to an average, the output of the cell
should look like this:
ABS 8.5
Thanks!!!
|