Sodie333

Q: Numbers - Remove Hyperlinks

Hi - I'm using the lastest version of Numbers on Maverick and I'm editing documents with links in them.  However, every time I make a change in a cell, the link turns to a hyperlink.  I know how to remove each one separate with the format key.  Is there a way to select the entire document at the end and remove all the hyperlinks at once?  Thx

MacBook Pro with Retina display, OS X Mavericks (10.9.2)

Posted on Mar 22, 2014 11:44 AM

Close

Q: Numbers - Remove Hyperlinks

  • All replies
  • Helpful answers

  • by SGIII,Apple recommended

    SGIII SGIII Mar 22, 2014 7:58 PM in response to Sodie333
    Level 6 (10,730 points)
    Mac OS X
    Mar 22, 2014 7:58 PM in response to Sodie333

    I don't think there is a way to remove all hyperlinks at once, but there is a way to prevent all those hyperlinks in the first place. Uncheck Smart Links in the Edit > Substitutions menu:

     

    Screen Shot 2014-03-22 at 10.52.34 PM.png

     

    SG

  • by Sodie333,

    Sodie333 Sodie333 Mar 27, 2014 10:30 AM in response to SGIII
    Level 1 (1 points)
    Mar 27, 2014 10:30 AM in response to SGIII

    Many thanks!! 

  • by TravelAgentDavid,

    TravelAgentDavid TravelAgentDavid Jan 14, 2016 10:22 AM in response to Sodie333
    Level 1 (0 points)
    Jan 14, 2016 10:22 AM in response to Sodie333

    Remove the check on the Substitutions first (See other reply).

     

    Then ...

     

    Highlight your links (you can grab contiguous cells)

    Edit -> Copy

    Edit -> Paste and Match Style

  • by Acecha,Apple recommended

    Acecha Acecha Feb 4, 2016 2:45 PM in response to Sodie333
    Level 1 (7 points)
    Feb 4, 2016 2:45 PM in response to Sodie333

    I had the same question and google point me to this post. Like this one, all other I found didn't help me so much, so I figured out something easy and worked for me.

     

    I had a large list of names of places (more than 3,000), taken from a web site, and with the process of copying and pasting to Numbers, I got the names I wanted, but with all its hyperlink also.

     

    Only one column had the names with hyperlink, and change manually one by one, it would be a hard work. My solution went export my Numbers file to CSV file. (File > Export to... > CSV)

     

    Of course, any text formatting, formulas, etc. also they disappear. So it can be taken only in the CSV file data as required. For me it was good to change only one column.

  • by Barry,

    Barry Barry Feb 4, 2016 8:08 PM in response to Acecha
    Level 7 (32,502 points)
    iWork
    Feb 4, 2016 8:08 PM in response to Acecha

    Hi Acecha,

     

    Alternate methods always welcome, Thanks for sharing!

     

    Regards,

    Barry

  • by Yellowbox,Apple recommended

    Yellowbox Yellowbox Feb 5, 2016 7:39 AM in response to Sodie333
    Level 6 (10,515 points)
    Mac OS X
    Feb 5, 2016 7:39 AM in response to Sodie333

    Hi Sodie,

     

    My preferred method is (as advised by TravelAgentDavid)

    Edit -> Copy

    Edit -> Paste and Match Style

     

    Adding to the good advice from SG, TravelAgentDavid  and Acecha, you may find the PLAINTEXT function will help sometimes.

    Screen Shot 2016-02-06 at 2.18.35 am.png

    Formula in C2 (and Fill Down)

    =PLAINTEXT(B2)

     

    Select Column C, Menu > Edit > Copy

    Menu > Edit > Paste Formula Results to "fix" the result

    Then you can delete Column B.

     

    Happy Numbering!

    Regards,

    Ian.

  • by Swampgoat,

    Swampgoat Swampgoat Feb 19, 2016 10:10 AM in response to SGIII
    Level 1 (4 points)
    iCloud
    Feb 19, 2016 10:10 AM in response to SGIII

    Thanks! This drove me crazy until I saw this answer.  Much appreciated!

  • by anklebyter,

    anklebyter anklebyter Sep 15, 2016 5:42 PM in response to SGIII
    Level 1 (8 points)
    Desktops
    Sep 15, 2016 5:42 PM in response to SGIII

    Thanks a MILLION, SGlll. I was just about to run out of my vast supply of really bad words trying to figure out why I was having this problem.