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

On Nov 16, 10:18 am, 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?


hi samb

the formula would be something like that:
=yourformula & " $ per hour"

for example:
=A1 + B1 * C1 & " $ per hour"

hth

Carlo