View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default 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