text and formula within the same cell

[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

 

[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.

 

[Guest]

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

 

[Guest]

Maybe this.......

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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.

 

[Guest]

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

 

[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

 

[Lucy]

Thank you to everyone who replied

Lucy

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