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

[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

 

[Gord Dibben]

=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

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

I have a problem similar your problem, what I did is I put a message using
Data - Validation -input message.

 

[Guest]

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

 

[Pete_UK]

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

 

[Gord Dibben]

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

 

[Guest]

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.

 

[Guest]

I do not understand how to use the custom format noted in your first reply.

#,##0.00 "*"

Please explain,

Tom

 

[Gord Dibben]

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

 

[Guest]

Thanks, the custom format worked perfectly.

Tom

 

[Gord Dibben]

Glad to hear that Tom

Gord

Thanks, the custom format worked perfectly.

Tom