title: concatenating a string and then executing the string statement using the concatenated string
body: <p>I have made many unique formulas using Concatenate. i.e. <code>=concatenate(lookupSheet$b$2,row(),if(a3&gt;50,lookupSheet$h$2,row(),....)</code> eventually generating strings that are unique Hlookups for differing data sets. </p>
  
  <p>When I paste the hlookup strings to another column, Excel treats it as text until I place the cursor in the Function field and press enter, then it treats it as the formula.  How can I perform this conversion on the entire pasted column at one time?</p>