| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell in excel contain text and have a formula included?
I want to have a string of text where the formula is included that will pull
information from another cell. ie: The number of attendees for training was (formula), which dropped from the last session. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a cell in excel contain text and have a formula included?
Like this:
="The number of attendees for training was " & (formula) & ", which dropped from the last session." HTH, Paul "pennpro" wrote in message ... I want to have a string of text where the formula is included that will pull information from another cell. ie: The number of attendees for training was (formula), which dropped from the last session. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a cell in excel contain text and have a formula included?
hi
="here you have your message "&a2 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "pennpro" escreveu: I want to have a string of text where the formula is included that will pull information from another cell. ie: The number of attendees for training was (formula), which dropped from the last session. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a cell in excel contain text and have a formula included?
And if you need to format the quantity or date:
="The number... " & text(a1,"#,##0.00") & ", which..." & text(b1,"mm/dd/yyyy") pennpro wrote: I want to have a string of text where the formula is included that will pull information from another cell. ie: The number of attendees for training was (formula), which dropped from the last session. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
