View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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