Ask Your Question

use a variable within text

asked 2018-03-09 04:02:13 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete



Please do not post as Wiki. It helps no one.

Ratslinger gravatar imageRatslinger ( 2018-03-09 04:06:11 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-09 04:14:19 +0200

Ratslinger gravatar image

updated 2018-03-09 04:38:59 +0200

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.

edit flag offensive delete link more


The parentheses are not necessary.

erAck gravatar imageerAck ( 2018-03-09 17:32:49 +0200 )edit

answered 2018-03-09 04:27:49 +0200

how0909 gravatar image

updated 2018-03-09 04:28:59 +0200

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!

edit flag offensive delete link more



You welcome.

In future, please use comment to respond. Answers should be used to respond to original question.

Ratslinger gravatar imageRatslinger ( 2018-03-09 04:36:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-09 04:02:13 +0200

Seen: 461 times

Last updated: Mar 09 '18