How do I combine text and a calculation in the same field?
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
"steshi" wrote in message
...
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
|