title: creating dynamic links
body: <p>I need to create a link that will look like following</p>
  
  <pre><code> =CONCATENATE("http://servernaem/SMSReporting/Report.asp?ReportID=104&amp;AdvertID=SCCM20067&amp;Name=", A5)
  </code></pre>
  
  <p>The problem is when I click the link, the data from <code>A5</code> is missing. (It does appear in the Excel spreadsheet.</p>
  
  <p>What would be a preferred solution is to have the work Status Report appear in the cell instead of the URL?</p>