Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Formula in one cell
I have a spreadsheet that has a cell with the answer to a formula, I would
like to add some text to this cell explaining what the answer is?? Does anyone have any ideas, I've tried changing the format to text and simply just typing it but have had no success?? HELP? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Formula in one cell
If the cell returns a number:
=a1+a2 +N("this is a comment describing the function") if the cell returns text: =a1&": "&text(a2,"mm/dd/yyyy") & text("this is a comment",";;;") Tracy wrote: I have a spreadsheet that has a cell with the answer to a formula, I would like to add some text to this cell explaining what the answer is?? Does anyone have any ideas, I've tried changing the format to text and simply just typing it but have had no success?? HELP? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Formula in one cell
Use the "&" symbol
E.g., ="The value of the first cell is "&A1 or =A1&" is the value of first cell, and the second cell is "&B2 Simply change the text to whatever you want, and replace cell references with your formula. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tracy" wrote: I have a spreadsheet that has a cell with the answer to a formula, I would like to add some text to this cell explaining what the answer is?? Does anyone have any ideas, I've tried changing the format to text and simply just typing it but have had no success?? HELP? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
Formula with cell column from cell text | Excel Discussion (Misc queries) | |||
Insert text from one cell into formula in another cell. | Excel Discussion (Misc queries) | |||
Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions |