title: Convert Literal Text to Formula
body: <p>Using MS Excel 2010: I used the CONCATENATE formula to create a text string that looks like a formula and need a formula that will convert the text string to a formula; without the use of MS Excel Paste Special function or VBA/Macro.</p>
  
  <p>Example: In Cell B2:G2 contains text, in Cell B4 I have CONCATENATE text formula that returns a text string </p>
  
  <pre><code>=TRIM(CONCATENATE(B2&amp;" "&amp;C2&amp;" "&amp;D2&amp;" "&amp;E2&amp;" "&amp;F2&amp;" "&amp;G2&amp;" "&amp;H2))
  </code></pre>
  
  <p>I want Excel to interpret this string as a formula and return/show the value in Cell B6 as:    "Always be yourself … do not go out and look for a successful personality and duplicate it.” - Bruce Lee</p>
  
  <p><a href="https://i.stack.imgur.com/AOY4X.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AOY4X.jpg" alt="enter image description here"></a></p>
  
  <p>I have attempted using the <code>INDIRECT</code> formula and without success, not certain if it's my formula or if it's possible.  SAMPLE: Cell B6:</p>
  
  <pre><code>=INDIRECT(CONCATENATE("B4"))
  </code></pre>