View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ISBLANK for a Range

And just to add to Dana's suggestion...

If the formula returns text, you could use:

="This is a date " & text(a1,"mm/dd/yyyy") & text("your comment here",";;;")

Dana DeLouis wrote:

Hi. If a function returns a number (not a string), you can add zero without
affecting the answer. Was this what you were thinking of:
=MAX(A1:A4)+N("Your comment here")

HTH :)
--
Dana DeLouis
Win XP & Office 2003

"Sige" wrote in message
ups.com...
Hi Tom,

Thx ...it is actually not a concatentate that I am looking for! ...

I mean a function that does not produce an output in the cell (like
multiplying with 1, not to affect the formula)... but that you can use
to comment the formula in the cell itself...and which is only visible
when you select the cell.

Sige


--

Dave Peterson