text and formula within the same cell

L

Lucy

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
 
D

Dave Peterson

=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.
 
C

CLR

Maybe this.......

=A4*B7&" Membership + "&C3*D10 &" Journals"

Vaya con Dios,
Chuck, CABGx3
 
S

Sloth

It would probably be better to use a standard formula like
=(A4*B7)+(C3*D10)
and then insert a comment to explain the formula (right click cell -> insert
comment). I don't think you can add notes to a formula inside the formula.
 
C

CLR

Sorry, I mis-read your post.....probably this will do as you wish.....

=(A4*B7)+(C3*D10)+N("Membership + Journals")


hth
Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Sloth

It is possible to add explanatory notes inside a formula.

Look at Dave P's post or see below...........

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The text after the n will show in the formula bar but not in the cell.


Gord Dibben MS Excel MVP
 
L

Lucy

Thank you to everyone who replied

Lucy

Gord said:
Sloth

It is possible to add explanatory notes inside a formula.

Look at Dave P's post or see below...........

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The text after the n will show in the formula bar but not in the cell.


Gord Dibben MS Excel MVP
Click to expand...
 
Top