title: Making a dynamic Hyperlink function static
body: <p>I had a column of values in column A, all with 6 digit numbers. In order to hyperlink each of these to a folder containing PDF files with the same 6-digit titles, I inserted the following function into cell A2:</p>
  
  <p><code>=HYPERLINK("C:\...Project\" &amp; A2 &amp; ".pdf", A2)</code></p>
  
  <p>This worked perfectly, and dragging it down through the thousand or so cells created hyperlinks for each entry. </p>
  
  <p>However, now I want to replace column A1 with these new hyperlinks. I thought I could paste-special the column of hyperlinks to remove the dynamic entries in each cells, but this doesn't seem to be possible. I'm sure there's an easier solution. Am I missing something? Can I make column B exist independent of column A before replacing it? Is there a VBA solution?</p>