View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default text and formula within the same cell

=a4*b7 +N("membership") + c3*d10 +N("Journals")
works with numbers.

And something like:

=A1 & " " & b1 & TEXT("this is a comment",";;;")
will work when you want to return Text.



Lucy wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks


--

Dave Peterson