Hi,
In my calc sheet I have the name ‘wage’ for a cell and put my wage value in there so I can use it other places.
I would like to use that variable within the text of another cell but can’t so far.
eg: “Current houly charge is =(wage) per hour”
I would think this is possible but I’m not seeing this explained in any posts so far.
Thanks
Please do not post as Wiki. It helps no one.
Hello @how0909,
Try =("Current hourly charge is " & (wage) & " per hour")
and =("Current hourly charge is " & wage & " per hour") also works.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
The parentheses are not necessary.
Yes, that does work, great thanks!
I had also found concatenate
=CONCATENATE(“Current hourly charge is $”, wage, " per hour")
but yours is shorter, just need to remember the '&'s.
Thanks again!
You welcome.
In future, please use comment to respond. Answers should be used to respond to original question.
You welcome.
In future, please use comment to respond. Answers should be used to respond to original question.