View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
LinLin LinLin is offline
external usenet poster
 
Posts: 46
Default Formula & text in one cell

Try also the function "concatenate"

=CONCATENATE (text1,text2,...)
So in your example
=CONCATENATE ("$16.99"," per hour")
If $16.99 is the end result of a calculation in, say, cell B2
=CONCATENATE (B2," per hour")
cheerio
LinLin

"samb" wrote:

I am trying to add a label to the numbers in one cell. I want the formula to
calculate the numbers, but then I want it to say "per hour" after the numbers
in the same cell. So, for example, the cell would read "$16.99 per hour"
How can I do this?