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

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

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

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

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.

--
HTH :)
Dana DeLouis
Windows XP & Office 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

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

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.

"Paul B" wrote:

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

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

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.

"Dana DeLouis" wrote:

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.

--
HTH :)
Dana DeLouis
Windows XP & Office 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

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

Hi

You could use Custom formatting of the cell
FormatCellsNumberCustom $ #.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.

--
Regards

Roger Govier


"steshi" wrote in message
...
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.

"Paul B" wrote:

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