title: How to force excel to open text in webbrowser?
body: <p>I have to perform alot of searches in Google, so I made a Excel document that simply inserts the text into the google link:</p>
  
  <p>"John" AND “Soccer” OR “Sport”</p>
  
  <p>"Andre" AND “Soccer” OR “Sport”</p>
  
  <p>For example in have the name "John"in cell A1 and I insert it in the following link.</p>
  
  <blockquote>
    <p><a href="https://www.google.nl/search?newwindow=1&amp;q=%22" rel="nofollow noreferrer">https://www.google.nl/search?newwindow=1&amp;q=%22</a><strong>&amp;A1</strong>%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;oq=%22&amp;<strong>A1</strong>%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;gs_l=serp.3...7614.32351.0.32567.17.17.0.0.0.0.345.1828.8j6j0j1.15.0....0...1c.1.64.serp..2.3.379...30i10k1.vLZ-hcrrdgg</p>
  </blockquote>
  
  <p>And it comes out like this:</p>
  
  <blockquote>
    <p><a href="https://www.google.nl/search?newwindow=1&amp;q=%22John%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;oq=%22John%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;gs_l=serp.3...7614.32351.0.32567.17.17.0.0.0.0.345.1828.8j6j0j1.15.0....0...1c.1.64.serp..2.3.379...30i10k1.vLZ-hcrrdgg" rel="nofollow noreferrer">https://www.google.nl/search?newwindow=1&amp;q=%22John%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;oq=%22John%22+AND+%E2%80%9CSoccer%E2%80%9D+OR+%E2%80%9CSport%E2%80%9D+&amp;gs_l=serp.3...7614.32351.0.32567.17.17.0.0.0.0.345.1828.8j6j0j1.15.0....0...1c.1.64.serp..2.3.379...30i10k1.vLZ-hcrrdgg</a></p>
  </blockquote>
  
  <p>I made this for all the names by simply dragging it down. And these are all links that actually sends me to the page I want to be on. But what i can't is "CLICK ON THEM" no matter what i try i can't make those cells clickable Hyperlinks.</p>
  
  <p>Next step is also that i want to print/Save them using Amyuni PDF. (this is not my biggest concern at the moment)</p>
  
  <p>Is there any way to force the text to open up in a browser? Using VBA for example.</p>
  
  <p>Thank You in advance, if you know a easier way to perform this I would like to hear that as well.</p>
  
  <p>Kind Regards!</p>