+ Reply to Thread
Results 1 to 4 of 4

Edit "Text to display" of dozens of hyperlinks simultaneously

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Edit "Text to display" of dozens of hyperlinks simultaneously

    I've got about three hundred active hyperlinks on a page that are super long and taking up a lot of screen real estate. Is there any way to highlight all three hundred of them and, while keeping the hyperlink active, convert the "text to display" to something more manageable like <Link>?

    I know there should be a pretty simple macro for this...

    They are hard coded hyperlinks (CTRL-K), not formulas.
    Last edited by JBeaucaire; 09-12-2014 at 07:24 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Edit "Text to display" of dozens of hyperlinks simultaneously

    If the hyperlinks were addresses just typed into the cell like www.google.com or entered using the Insert, Hyperlink, you can right click on the hyperlink and choose Edit Hyperlink and enter a "Friendly Name" for the hyperlink. If entered via formula, you can enter a "Friendly Name" in the formula bar for identification.

    If the entries are typed in column C as http://www.microsoft.com or www.google.com you could enter this to extract the name and the result is a hyperlink

    Enter this where you want the short form:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you are wanting to reduce the 300 hyperlinks to a single link on a worksheet, have all the hyperlinks on a worksheet and insert a hyperlink where they were that when clicked goes to the list of hyperlinks. Then have a hyperlink on the worksheet with the links that when clicked returns to the original position on the original worksheet.
    Last edited by newdoverman; 09-12-2014 at 07:47 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Edit "Text to display" of dozens of hyperlinks simultaneously

    The OP has indicated hardcoded hyperlinks, press CTRL-K on a cell to see that option. These are URLs types as text. When you CTRL-K to open the hyperlink wizard window, he wants to change the existing hyperlinks "Text To Display" in an entire column of these hardcoded hyperlinks to "Link".
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  4. #4
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Edit "Text to display" of dozens of hyperlinks simultaneously

    Well I don't fully understand the macro language behind it, but I found a solution. This little macro fit the bill perfectly.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    With "Link" being edited out for whatever I wanted the text to display to be.

+ 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. Replies: 10
    Last Post: 09-06-2017, 06:04 PM
  2. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  3. Replies: 1
    Last Post: 09-15-2010, 01:55 AM
  4. Search for "text" in description - if certain text - display "text" in another row
    By mjj047s in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-07-2006, 10:30 AM
  5. Replies: 0
    Last Post: 08-24-2005, 04:05 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