+ Reply to Thread
Results 1 to 7 of 7

How to convert text links to hyperlinks?

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Sofia
    MS-Off Ver
    Excel 2007
    Posts
    67

    How to convert text links to hyperlinks?

    I have a column with text links which i want to convert to hyperlinks. How can i do that? I tried with the formula =hyperlink but it doesn't work, i can't copy the formula links as hyperlinks.
    I am using Excel 2007.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,774

    Re: How to convert text links to hyperlinks?

    can you provide a couple examples?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: How to convert text links to hyperlinks?

    Here's the correct syntax:
    Please Login or Register  to view this content.
    The red section is the URL, the rest is the "friendly text" (label). So you'll use a cell ref in place of the URL:
    Please Login or Register  to view this content.
    Last edited by leelnich; 02-01-2018 at 02:18 PM.
    Clicking the Add Reputation star below any helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion. (Thread Tools above Post # 1) Thanks!-Lee

  4. #4
    Registered User
    Join Date
    04-15-2011
    Location
    Sofia
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: How to convert text links to hyperlinks?

    Quote Originally Posted by leelnich View Post
    Here's the correct syntax:
    Please Login or Register  to view this content.
    The red section is the URL, the rest is the "friendly text" (label). So you'll use a cell ref in place of the URL:
    Please Login or Register  to view this content.
    I can't copy/paste the converted links. It paste them as plain text links, not as hyperlinks.

  5. #5
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: How to convert text links to hyperlinks?

    Paste this macro in a standard module. In the cells to the RIGHT of your URLs, type the corresponding Friendly_Names. Then select the cells containing your URLs, press ALT+F8 to bring up the Macro Dialog Box, and run the macro. Each cell in the selection will be converted.
    Please Login or Register  to view this content.
    URLs Friendly names
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly1
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly2
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly3
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly4
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly5

  6. #6
    Registered User
    Join Date
    04-15-2011
    Location
    Sofia
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: How to convert text links to hyperlinks?

    Quote Originally Posted by leelnich View Post
    Paste this macro in a standard module. In the cells to the RIGHT of your URLs, type the corresponding Friendly_Names. Then select the cells containing your URLs, press ALT+F8 to bring up the Macro Dialog Box, and run the macro. Each cell in the selection will be converted.
    Please Login or Register  to view this content.
    URLs Friendly names
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly1
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly2
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly3
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly4
    https://www.excelforum.com/excel-general/1218050-how-to-convert-text-links-to-hyperlinks.html#post4834110 Friendly5
    Thanks, the macro worked.
    What about copy/paste the =hyperlink formula links? Is that possible?

  7. #7
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: How to convert text links to hyperlinks?

    If you mean copy formulas / paste values, I couldn't find a way to make that work - which is why I went w/ a macro.

    PS. It's not really necessary to quote posts unless:
    1) There are un-related posts between the referenced post and the reply AND/OR
    2) You wish to respond to a particular point... in which case you should delete irrelevant text to emphasize that point.
    Last edited by leelnich; 02-01-2018 at 04:36 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert Hyperlinks to text
    By breet77 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-22-2012, 05:44 PM
  2. Macro to convert text urls to active hyperlinks
    By tdm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2012, 02:19 AM
  3. Convert list of text links into Hyperlinks?
    By jaustin008 in forum Excel General
    Replies: 1
    Last Post: 07-08-2012, 04:14 PM
  4. Cell that links to two possible hyperlinks?
    By djmarak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-24-2007, 10:14 AM
  5. Macro to convert hyperlinks to text
    By Emece in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2005, 10:20 AM
  6. [SOLVED] Hyperlinks:is it possible to change the links automaticaly ?
    By steve.a in forum Excel General
    Replies: 1
    Last Post: 12-09-2005, 12:00 PM
  7. How to convert all rows of a text column to hyperlinks?
    By zartania in forum Excel General
    Replies: 0
    Last Post: 02-02-2005, 10:09 AM
  8. [SOLVED] Convert entire columns of text email addresses to hyperlinks
    By TSA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1