Skip to main content

Extracting URL from hyperlink function

Hi all, I currently have a hyperlink function that is meant to go straight to the first returned search (like I'm Feeling Lucky) on a keyword (from column D) from a specific website (mindat.org). It looks like this:

=HYPERLINK(CONCATENATE("http://ift.tt/2h1hfnh;," ",D2))

For example, cell D2 is "Lookout Prospect" and is directed to http://ift.tt/2z4sh26.

I'd like to have that URL (and the 4185) in additional columns. This is my first crash course in excel/sheets and I'd really be grateful for some guidance.

Thanks!



Submitted November 01, 2017 at 05:23AM by olivine http://ift.tt/2h1hgrl
Labels:

Comments

Post a Comment

Popular posts from this blog

certain keys on my keyboard dont work when "cold"

Hi guys, i have a Lenovo Y520-15IKBN (80WK) and certain keys on the keyboard don't work (e,g,h,8,9,Fn...) but only when the weather is cold. for example in the winter it used to work after certain amount of time when i first boot the laptop and stops working when i stop using it for a while, but now that the weather is hot it works just fine except for the first couple of minutes or when its colder. of course i do realise that it has nothing to do with the outside weather but with the temperature of the computer itself. can someone explain to me why this is happening and how it should be fixed as i cannot take it to the tech service until july even though it's still under warranty because i need it for school. ps: an external keyboard works fine. Submitted April 29, 2018 at 03:35PM by AMmej https://ift.tt/2KiQg05
Post a Comment
Read more

Old PC with a Foxconn n15235 motherboard needs drivers! Help!!

So my Pc corrupted and I had to fresh install windows on it, but now its missing 3 drivers and one of them is for the Ethernet controller! I've tried searching everywhere for the windows 7 drivers but all I seem to find are some dodgey programs saying they will install it for me. Problem is without the ethernet driver I can't bloody connect to the internet. I've been using a USB to try get some drivers on there, but they just end up being useless programmes . I'm also a bit of a noob at these things, I don't understand where to find the names of things in my PC, I've opened it up but I don't understand whats significant and what isnt. If someone has the drivers and can teach me how to install them I'd be very appreciative! Submitted April 29, 2018 at 02:47PM by darrilsteady https://ift.tt/2r76xMZ
Post a Comment
Read more