+ Reply to Thread
Results 1 to 3 of 3

Converting text URLs to hyperlinked URLs

  1. #1
    Registered User
    Join Date
    11-17-2006
    Location
    Chicago, IL
    Posts
    10

    Converting text URLs to hyperlinked URLs

    I have a client who sends me a listing of their branch offices' hyperlinks for processing, but they are always in text. Maybe they are coming in from a database or something, I really don't know. The list is in perfect vertical order on the Excel spreadsheets, but each link is not "hot", only text. I know that I can hi-light each one, hit the spacebar and Exel converts it into a hot hyperlink, but this is becoming seriously tedious. I searched the forum and found this, which seems to be close to my problem:
    http://www.excelforum.com/excel-gene...lain-text.html

    The problem is that I know nothing about macros so I don't understand the explanation. I am picturing, maybe, hi-lighting the entire page list, and using a "miracle" key combination to convert the whole thing into hyperlinks at one crack. Or something. Can anyone step me through setting up a page so that I can easily convert these lists of text URLs into hyperlinked URLs?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Converting text URLs to hyperlinked URLs

    Hello ranchhand,

    This macro will restore the hyperlinks in a single column on the active sheet. When run, the macro will prompt you to select the cells you want to convert. After you have selected the cells, click "OK" and your done.

    Please Login or Register  to view this content.

    Adding the Macro
    1. Copy the macro above pressing the keys CTRL+C
    2. Open your workbook
    3. Press the keys ALT+F11 to open the Visual Basic Editor
    4. Press the keys ALT+I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Paste the code by pressing the keys CTRL+V
    7. Make any custom changes to the macro if needed at this time.
    8. Save the Macro by pressing the keys CTRL+S
    9. Press the keys ALT+Q to exit the Editor, and return to Excel.

    To Run the Macro...
    To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

  3. #3
    Registered User
    Join Date
    11-17-2006
    Location
    Chicago, IL
    Posts
    10

    Re: Converting text URLs to hyperlinked URLs

    Hey Leith, that did it. What a relief!! Thank you very much for the prompt and spot-on help. I apologize, but I clicked on the scales and I get a pop-up box, something about reputation points (?). I would like to post as solved but I can't get past that "reputation" box and I don't understand what it is asking or what reputation points are. Sorry.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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