If we have some cells with actual hyperlinks contained within them, is there a way via SEOTools for Excel to extract the URL from that cell? The methods I've seen so far involve using VBA code or some other third party Excel plugin, which I would like to avoid if possible.
Hi Tom,
If I understand your issue correctly, you'll want to couple the formula for a SeoTools function with a cell reference[1].
=HtmlMetaDescription(A3)
The above example would fetch the Meta Description from the URL contained in the cell A3.
Actually, what I was referring to is if I were to select and copy a list of links from a web page, and paste that into Excel - they would be live links in Excel - not just text (unless of course I chose "Paste as text" instead). Is there a way with this plugin to extract the actual URL's from those live links in Excel?
Don't think you need any help from SeoTools in this case. Links in Excel are treated just as text. If you want to remove the link property and convert to a text cell just highlight the cells right click and select "Remove hyperlink".
Sorry, I should have been more clear - I'm talking about instances where the anchor text isn't a URL, but rather something like "click here for more information" and it's a live hyperlink in an Excel cell, and I'm trying to extract the underlying URL.
Ok now I understand. No there's no feature for this in SeoTools. VBA seems to be the way to go: http://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel
Macros are perfect for this. I set one up about 7 years ago and still use it today...! It comes in very handy.