How do I combine text and a calculation in the same field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steshi - 20 Nov 2006 02:40 GMT

I am trying to do a calculation and have text follow that in the same field.
An example might be as follows : =(H30/4) per week

I want the calculation to be there, be a space and then the words "per week"
in the same field. I do not have room for another column just for those two
words.
If anyone can help, I would appreciate it very much. Thanks, Stephanie

Reply to this Message

Paul B - 20 Nov 2006 02:49 GMT

steshi, try this,

=H30/4 & " per week"

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I am trying to do a calculation and have text follow that in the same field.
> An example might be as follows : =(H30/4) per week
[quoted text clipped - 3 lines]
> words.
> If anyone can help, I would appreciate it very much. Thanks, Stephanie

Reply to this Message

steshi - 20 Nov 2006 03:16 GMT

That did add the text....thanks. The only thing is that it dropped the
formating. Actually, if I go to the "cell format" the format is what I set
it to be but it dropped the "$" so rather than it displaying " $980.25 per
week", it displays " 980.25 per week" with no dollar sign.

> steshi, try this,
>
[quoted text clipped - 10 lines]
> > words.
> > If anyone can help, I would appreciate it very much. Thanks, Stephanie

Reply to this Message

Roger Govier - 20 Nov 2006 11:37 GMT

Hi

You could use Custom formatting of the cell
Format>Cells>Number>Custom> $ #.00 "Per Week"

The in your cell just enter =H30/4
This has the advantage, that the value in the cell is still numeric and
can be used in further calculations if required.

Signature

Regards

Roger Govier

> That did add the text....thanks. The only thing is that it dropped
> the
[quoted text clipped - 22 lines]
>> > If anyone can help, I would appreciate it very much. Thanks,
>> > Stephanie

Reply to this Message

Dana DeLouis - 20 Nov 2006 03:07 GMT

If you wish to limit the number of decimal places display, perhaps one of a
few ways:

=TEXT(H30/4,"$ #.00 ""Per Week""")

Another common option is to add a custom format to the cell:
#.## " Per Week"

This allows you to continue to use the cell as a value, and not as a text
string.

Signature

HTH :>)
Dana DeLouis
Windows XP & Office 2003

>I am trying to do a calculation and have text follow that in the same
>field.
[quoted text clipped - 6 lines]
> words.
> If anyone can help, I would appreciate it very much. Thanks, Stephanie

Reply to this Message

steshi - 20 Nov 2006 03:34 GMT

That did it. Thank you so much. To remember that first option, I will need
to analyze it more so that I understand all the logic. The second option for
setting up a custom format is way easier to understand and establish. I am
very excited to have learned this. Thanks again.

> If you wish to limit the number of decimal places display, perhaps one of a
> few ways:
[quoted text clipped - 17 lines]
> > words.
> > If anyone can help, I would appreciate it very much. Thanks, Stephanie

Reply to this Message