SQL / Excel question

[BigV]

I am trying to import data from an Excel worksheet into a SQL database, using DTS. The column in the worksheet that I need the most is filled with hyperlinks, ala =HYPERLINK(linklocation, friendlyname). When I import the data, all I get is the friendlyname. :grr:

Here's the question. Does anyone know of a DTS transformation to read the contents of the Excel cell and extract the linklocation? Or, failing that, does anyone know of an Excel function (macro, formula, etc non-manual way) that will do the same thing, take the contents of the cell containing the hyperlink and only display the linklocation part?

MUCH thanks in advance. I will pay a bounty to the tip jar in the name of the puzzle solver for an answer today.