And to piggyback on Gord's response...

If you had a formula that returned text, you could use:

="Due date: " & text(a1,"mm/dd/yyyy") & text("a note goes here",";;;")



Gord Dibben wrote:

=100+N("new garden hose")

100 will be displayed but in formula bar you will see the full text.

Gord Dibben MS Excel MVP

On Sun, 8 Nov 2009 14:41:01 -0800, Grant
wrote:

So, I have data cells in an Excel spreadsheet. The row has a heading, like
"misc house expenses", but I want to be able to know specifically why I had a
$100 item in column 26, like "new garden hose". How do I do that? Thanks.

--

Dave Peterson