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

[Guest]

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

 

[Paul B]

steshi, try this,

=H30/4 & " per week"

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

 

[Dana DeLouis]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Roger Govier]

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.