I have one coulumn that has the url. I have another column that has the name I want to hyperlink to. In the end, I want a columm that has the name made into a hyperlink. Please help. I'm going crazy!
I have one coulumn that has the url. I have another column that has the name I want to hyperlink to. In the end, I want a columm that has the name made into a hyperlink. Please help. I'm going crazy!
The cell where you want your hyperlink to appear right click and hit
Hyperlink. On the top you will see a dialog box that says "Text to
display" enter what you want the link to say, then on the bottom where
it says "address" that's where you want the link to go, url or internal
link to another document.
You can also use the buttons on the left to take the cursor to a
particular cell (Place in this document) and all kinds of other fun
things.
Anyway...hth
That is great. Problem is, I have about 30,000 lines to do. That might take a while to write each one. I'm looking for a formula that will combine the text in one column with the url in another and then drag that formula down through the 30,000 lines.
I'm thinking that it will need perhaps some variation of one of the below formulas:
=hyperlink(concatenate("b12785,Q12785))
=hyperlink (B12785,Q12785)
But I haven't got it to work yet.
The second one is correct
=HYPERLINK(A2,B2)
with the URL in A2 and the name in B2
will return the name as a link to the URL
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"johnnstacy" <[email protected]> wrote
in message news:[email protected]...
>
> I'm thinking that it will need perhaps some variation of one of the
> below formulas:
>
> =hyperlink(concatenate("b12785,Q12785))
>
> =hyperlink (B12785,Q12785)
>
> But I haven't got it to work yet.
>
>
> --
> johnnstacy
> ------------------------------------------------------------------------
> johnnstacy's Profile:
> http://www.excelforum.com/member.php...o&userid=27302
> View this thread: http://www.excelforum.com/showthread...hreadid=541294
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks