| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and formula in the same cell - how do I format this cell?? | Excel Discussion (Misc queries) | |||
| Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
| Text appear in formula bar but not in cell | Excel Discussion (Misc queries) | |||
| Text in cell as Formula | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
