I'm not sure if I understand your question, but if you want to hide comment text
to a cell that is text, you can do something like:

=A1&B1&"hi there"&TEXT("this is a comment",";;;")

If you give a cell a custom format of ;;; (3 semicolons), then that cell will
look empty. Same thing in the =Text() function.

It kind of mimics the:
=a1+b1+33+N("this is a comment")
version.

Mantvydas wrote:

Thank you for a prompt reply.

Regarding mswish. Strange, because I just used a Help - Contact Us... right
from the Office Excel 2003 application. It then led to the website, which had
a link called
Make a suggestion
Use our Make a Suggestion Wizard to submit ideas for any Office product or
Office Online feature.
And here I am. Don't [MSFT] people read it and take anything further? Then
they shouldn't be mistaking us with such a link sequence.

Regarding the N function. Wow! The function which returns 0 when text is
given. A smart idea. I would definitely use it. However, it also has a
drawback, that you cannot add integer up if you have text as result of the
function.

Thanks!

"JulieD" wrote:

Hi

if you'ld like to direct a request to microsoft then you'll need to email
them at

with Excel in the subject line.

this is a user based peer-peer discussion group providing assistance and
information on specific requests regarding excel. However, if you're post
was a request asking how comments can be included in formulas then this can
be achieved as per the following example:

=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) +N("number of days in the current
month.")

Regards
JulieD

"Mantvydas" wrote in message
...
Sometimes in worksheets the formulas can get out of hand, and when you
open a
file a while after you last touched it, you can no longer understand some
formulas you have in your worksheets.

Can you please include syntax for cell function parser, so that it is
possible to add any comment text after the last bracket and it'd just
ignore
it. You can even have an apostrophe like in VB to avoid inveting a wheel.

Say, such a formula including comment could be valid in a cell:
=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) 'counts number of days in a
current month.






--

Dave Peterson