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

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

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

=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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

"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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

On Aug 18, 11:48 pm, twb111 wrote:
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



"Gord Dibben" wrote:
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

On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:

=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

On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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- Hide quoted text -

- Show quoted text -

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

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

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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.


"twb111" wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

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

#,##0.00 "*"

Please explain,

Tom

"Gord Dibben" wrote:

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

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

FormatCellsNumber TabCustom

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

On Sun, 19 Aug 2007 09:26:11 -0700, twb111
wrote:

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

#,##0.00 "*"

Please explain,

Tom

"Gord Dibben" wrote:

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

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

Thanks, the custom format worked perfectly.

Tom


"Gord Dibben" wrote:

FormatCellsNumber TabCustom

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

On Sun, 19 Aug 2007 09:26:11 -0700, twb111
wrote:

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

#,##0.00 "*"

Please explain,

Tom

"Gord Dibben" wrote:

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

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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

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

Glad to hear that Tom

Gord

On Sun, 19 Aug 2007 12:36:00 -0700, twb111
wrote:

Thanks, the custom format worked perfectly.

Tom


"Gord Dibben" wrote:

FormatCellsNumber TabCustom

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

On Sun, 19 Aug 2007 09:26:11 -0700, twb111
wrote:

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

#,##0.00 "*"

Please explain,

Tom

"Gord Dibben" wrote:

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

On Sat, 18 Aug 2007 15:48:07 -0700, twb111
wrote:

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


"Gord Dibben" wrote:

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


On Sat, 18 Aug 2007 14:40:00 -0700, twb111
wrote:

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" wrote:


=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


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

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