Skip navigation

How to convert hyperlinks to url

1137 Views 17 Replies Latest reply: Dec 7, 2012 12:01 PM by Hiroto RSS
1 2 Previous Next
anon app Level 1 Level 1 (0 points)
Currently Being Moderated
Nov 26, 2012 1:14 PM

I have a column of data that includes embedded hyperlinks. I would like to simply transform the embedded hyperlinks into URLs. How can I do this?

 

So the following 2 cells...

Screen Shot 2012-11-26 at 10.57.22 PM.png

...must be:

 

leted http://www.xxxxxx1 and http://www.xxxxxx3.

leted http://www.xxxxxx2 and http://www.xxxxxx4.

 

where http://www.xxxxxx# are the urls Numbers points to when you click on this unpleasant blue text.

 

 

 

I hoped to find a killALLhyperlinks() function...

  • Wayne Contello Level 6 Level 6 (12,665 points)
    Currently Being Moderated
    Nov 26, 2012 2:49 PM (in response to anon app)

    I am not aware of a way to drop the link text and extract the URL from the hyperlink.  The only thinkg I could come up with is to view the page source in a web browser and copy the URLs.  In Safari you can type the key combination:

    <COMMAND> + <OPTION> + u to view the html source

  • Wayne Contello Level 6 Level 6 (12,665 points)
    Currently Being Moderated
    Nov 28, 2012 10:19 AM (in response to anon app)

    You can post feedback to Apple from the Numbers Application by selecting the menu item:

    "Numbers > Provide Numbers Feedback"

     

    I think the feature you want is not a commonly needed function as this is the first time I have seem a question regarding this.  Numbers is a good program for most needs but is certainly not a end-all-be-all application

  • Wayne Contello Level 6 Level 6 (12,665 points)
    Currently Being Moderated
    Nov 28, 2012 11:05 AM (in response to anon app)

    I understand you are frustrated and disappointed with Numbers.  Not only is the first time I have seen this request on these forums I personally have never once (really) wanted to do what you are doing.  That does not mean that the function is not relevant or important.  Apple targets the 80% solution and the software costs $20-- so it has limitations.

     

     

    I do not sure you can expect Numbers to do everything.  It is very common in my experience that I have to do some tasks outside of Numbers.  LibreOffice is a good office clone and there are others (NeoOffice, etc).

     

    finally... don't forget no one in these forums has any influence on the features of iWork applications... we are users like you.

     

    Best regards,

    Wayne

  • Wayne Contello Level 6 Level 6 (12,665 points)
    Currently Being Moderated
    Nov 28, 2012 11:24 AM (in response to anon app)

    There are a couple apps in the App Store (I entered "URL" in the search field)

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Nov 28, 2012 6:28 PM (in response to anon app)

    If you do choose to do this in Excel, it does not appear that the script (custom function) you linked to will do what you need. It appears to return a single hyperlink from a cell not the multiple hyperlinks you need. I believe you will have to modify it, maybe with a third parameter to specify which hyperlink to return.

     

    I think it is laughable you call Wayne a "fanboy" when he is telling you an Apple product can't do what you need it to do. The term "fanboy" is usually applied to those who say Apple's products are more capable and easier to use than anyone else's. 

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Nov 29, 2012 3:22 AM (in response to anon app)

    You have to post here a while before the report button will show up.

     

    I am interested to hear what answer you thought was not 100% on-topic, objective, and informed.  I'll be happy to report it for you. As far as I can tell all the answers were on-topic (i.e., pertained to your question), objective (even going so far as to recommend non-Apple software as a solution), and informed (i.e., the responder was knowledgeable and the answer was correct).

  • jaxjason Level 4 Level 4 (3,320 points)
    Currently Being Moderated
    Dec 5, 2012 1:50 PM (in response to anon app)

    If Numbers indeed has no way to manipulate hyperlinks...makes me wonder how small  this product's  userbase is.....
    ....

    I notice that the macro in my link doesn't fit my need 100% to the dot. But hey it's 200% more than what Numbers could ever hope to do

     

    How is Applescript any different than using VBA to solve your problem? Both are adding funtionality to an application to accomplish something that you see as "missing".

     

    How is the VBA solution 200% of the solution offered by Applescript?

     

    Regards,

    Jason

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Dec 5, 2012 5:41 PM (in response to jaxjason)

    I couldn't find a way to get an embedded URL from a cell using Applescript. It appears you cannnot access the URL from the cell, at least not using the Numbers suite. Maybe there is a way to get it from the clipboard if you copy a cell to the clipboard (as part of an Applescript script) but I didn't figure out how to do it. So right now it is 0% for Numbers.

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.