MaggieL:
Very good explanation of my situation. It is incomplete, though. While the book reference you describe is accurate, the contents of the problem cells on my worksheets achieve the same result with the Insert/Edit Hyperlink wizard. While the wizard is very good and helpful, it hides the linklocation data *somewhere* I can't find yet.
For example:
=HYPERLINK("http://www.google.com","bigSearchEngine")
is not the same as (see attached image).
Unfortunately, when I inspect the contents of the cell with the hyperlink created with the wizard, all I see is the friendlyname. When I manually recreate the same link using the =hyperlink(linklocation, friendlyname) syntax, it behaves the same way except the contents of the cell is "=hyperlink(linklocation, friendlyname). Now I have a string I can possibly work with.
I'm stuck at finding a way to get at the wizard created hyperlinks' linklocation data. I can edit the hyperlink and manually extract/copy the information, but that is tedious and filled with potential operator error, especially in light of the fact that there are thousands of rows.
Quote:
|
Originally Posted by MaggieL
It would be easier if his data was like:
-+---------A------------------------ B-------------------------C
1| =HYPERLINK($B$1,$C$1) | "http://www.google.com" | "bigSearchEngine"
|
Excellent example, and correct, but my worksheet's not there yet. I don't have a way to get all of the data inside the parentheses out yet.
My offer to hit the tip jar stands. I would happily pay the cellar on Gwennie's behalf for an answer.