Text & formula in same cell
 

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!!!

Text & formula in same cell
 

="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!!!

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!!!

Text & formula in same cell
 

Try this:

="ABS" & ROUND(Core!D55,1)


--
Biff
Microsoft Excel MVP


"Raza" wrote in message
...
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!!!

Text & formula in same cell
 

It worked like a charm! Thanks

"T. Valko" wrote:

Try this:

="ABS" & ROUND(Core!D55,1)


--
Biff
Microsoft Excel MVP


"Raza" wrote in message
...
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!!!

Text & formula in same cell
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Raza" wrote in message
...
It worked like a charm! Thanks

"T. Valko" wrote:

Try this:

="ABS" & ROUND(Core!D55,1)


--
Biff
Microsoft Excel MVP


"Raza" wrote in message
...
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!!!