Share via

Convert a list of Text Urls to Hyperlinks in Excel

Anonymous
2022-01-06T22:46:43+00:00

Hello,

A result of an sql query provided urls as output into an Excel spreadsheet.

Using: Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20332) 64-bit

I would like the results to clickable as urls.

Currently they seem to be in text and non clickable

The fx Hyperlink is good only for 1 line...I have 920 lines...and more to come.

I am unable to click a range of cells with the HYPERLINK

This is what happened when I tried using Hyperlink - it only gave did the first one. The rest stayed the same.

How do I convert multiple text urls ro Hyperlinks?

Thoughts or suggestions?

Below is some data.

Thanks for your time and patience, Experts!

HomePage
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
https://website.com/pages/viewpage.action?pageId=
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-01-07T18:35:10+00:00

    Enter your formula into cell B2, not A2. A2 has the value for the function.

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-06T22:59:13+00:00

    Use just one cell in the HYPERLINK function :

    =HYPERLINK (A2)

    Then copy that formula down to match your list in A.

    You can also create 'friendly' names for the links, using a function like

    =HYPERLINK(A2,IFERROR(MID(A2,FIND("=",A2)+1,LEN(A2)),""))

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-01-07T16:34:02+00:00

    Use just one cell in the HYPERLINK function :

    =HYPERLINK (A2)

    Then copy that formula down to match your list in A.

    You can also create 'friendly' names for the links, using a function like

    =HYPERLINK(A2,IFERROR(MID(A2,FIND("=",A2)+1,LEN(A2)),""))

    Thanks for that...but now having a problem when I tired it again.

    When I try to use the hyperlink fxn...

    Thanks!

    0 comments
  3. Anonymous
    2022-01-07T20:11:38+00:00

    Thank you so much for making this easy!

    0 comments