title: Hyperlinking ID's in Excel
body: <p>So i have a huge list of ID's in Excel (1000's),that all need to by hyperlinked. And the id's are the last part of the URL. </p>
  
  <p>How do i Auto hyperlink the entire column? </p>
  
  <p>Example.</p>
  
  <p><a href="http://www.website.com/cusid=#######" rel="nofollow">http://www.website.com/cusid=#######</a>  </p>
  
  <p>The ####### Being the ID in the Excel Column. </p>
  
  <p>What would be the formula for that. =HYPERLINK("<a href="https://www.website.com/custID=" rel="nofollow">https://www.website.com/custID=</a>"????)  would be the base i assume. What do i put in ??? to auto fill the ID after the custID= in the link.</p>