And if you wanted to include a comment in a formula that returned text:

="Due date is: " & text(a1,"mm/dd/yyyy") &text("another comment here",";;;")

Just in case you ever need it <bg.

Ian Elliott wrote:

Thanks for any help.
I was wondering if I could put a comment in the same line as a formula.
Something like:
=41500+32000 'this is reserve plus commission
or
=41500+3200 !this is reserve plus commission
or whatever the comment character is, if there is one.
Thanks.

--

Dave Peterson