Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I do not want to concatenate a string or show the value like "Some Text " & C12. I need to use the text in a cell as part of the formula in another cell. For Example:

I have a cell containing a date 17.02.2014. I need to use that date in a formula within another cell:


However this date needs to be pulled dynamically, for this example from E26. I would have expected it to look something like:


What is the correct syntax?

share|improve this question

Please try:


Indirect is able to read a string as a cell reference. Within the parentheses three elements are concatenated: the content of E26 (which could be as here a sheet named 17.02.2014), the required "!" and the content of AV6 (anchored with $s so it does not change if the formula is copied around).

share|improve this answer
Hey pnuts, I have tried the code and get "error: Parse error"?? – Kieran Headley Feb 18 '14 at 8:47
This is the top answer to a question with 1882 views... but it's really hard to read because of all the apologies and editorial remarks. Would you like to clean it up just to say what the answer is? – ᴡᴏʀᴅs Nov 22 '15 at 22:51

The INDIRECT function will only accept a range, as explained in the Drive Help: enter image description here

The thing with functions like NOW() and TODAY() is, that they do just that !!

The way to go is by referencing indirectly, like shown in the screenshot (C5 vs. C1).


enter image description here


I've created an example file for you: How to Use Text from a cell in a formula



share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.