We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

use a variable within text [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-11-25 12:36:14.740268



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

Question Tools

1 follower


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

Seen: 854 times

Last updated: Mar 09 '18