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
|