how do I add text in the same cell with a fomula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add a footnote reference (*) in the same cell with a formula. I
want the cell formula results to look this.

368 *

Thanks,

Tom
 
=yourformula & "*"

But you would not be able to use that cell as a reference in another formula
because the cell contents are Text and not numeric to be used in further
calculations.

If you need that cell to remain numeric use a custom format of

#,##0.00 "*"


Gord Dibben MS Excel MVP
 
I am not followng this. Please bare with me. How do i write the formula with
text so that the I can reference the cell in another formular. My formula is
very basic.

=A1+B1+25 I need to add a footnote to explin the where the number 25 comes
from.
Results I am looking for. 368 *

Thanks, Tom
 
I don't get nekkid with people I don't know so I won't "bare" with you.

=A1+B1+25 & " *" will give you 368 *

Or custom format as I noted.

Rather than a footnote maybe you could try this.

=A1+B1+25+n("the 25 comes from my pocket")

You will see 368 in the cell but in the formula bar you will see the footnote as
well as the formula.


Gord
 
I have a problem similar your problem, what I did is I put a message using
Data - Validation -input message.
 
The first formula =A1+B1+25 & " *" does give me 368 *, but I can not use
this cell reference in another formula. This is my prefered results, but i
need to reference the results in other cells.

Thanks, Tom
 
If you want to use the numeric value of this cell, then you can do the
following:

=1*LEFT(C1,LEN(C1)-2)

If you are carrying out arithmetic on the value, then you can omit the
1* bit at the beginning.

Hope this helps.

Pete
 
I know that and mentioned it in my first reply.

So did you try the Custom Format?

Or the other suggestion?

See Mike's suggestion also.


Gord
 
If you need to reference the formula result in another formula, I suggest
adding a hidden column, putting the formula in that column. That way you can
reference it in the column you want to add text, and in other formulas.

column c contains the formula: =A1+B1+25

column d contains the following: = c1 & "*"

you can then hide column c.
 
I do not understand how to use the custom format noted in your first reply.

#,##0.00 "*"

Please explain,

Tom
 
Format>Cells>Number Tab>Custom

Click on the #,##0.00 so's it appears in the "Type" dialog box.

Point into that dialog box with your mouse then add "*" and OK

If you want a space like 368 * use " *"


Gord
 
Back
Top