| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you display the contents of an excel cell in a sentence
Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our
yearly total |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you display the contents of an excel cell in a sentence
Try this (all on one line):
="The total cars sold this month was "&A35 &" which is "&D4&" % of our yearly total" Depending on the formats of the referenced cells, we might have to tweak it a bit. See how that works. -- Biff Microsoft Excel MVP "Ozinus" wrote in message ... Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you display the contents of an excel cell in a sentence
On Wed, 24 Dec 2008 19:07:00 -0800, Ozinus
wrote: Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total ="The total cars sold this month was " & A35 & " which is " & TEXT(D4, "0.0%") & " of our yearly total" --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you display the contents of an excel cell in a sentence
="The total cars sold this month was "&A35&" which is "&D4&
"% of our yearly total" The above formula should all be on one line. -- Rick (MVP - Excel) "Ozinus" wrote in message ... Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a cell in a user form text box -- Excel 2003 VBA | Excel Discussion (Misc queries) | |||
| Big Cell Contents - I don't want them to display | Excel Discussion (Misc queries) | |||
| Automatically display sentence. | New Users to Excel | |||
| Display Automatic sentence after filter. | New Users to Excel | |||
| display contents of cell | Excel Discussion (Misc queries) | |||
Linear Mode
