Numbers - Remove Hyperlinks

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.

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

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

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:

SG

Hi Acecha,

Alternate methods always welcome, Thanks for sharing!

Regards,

Barry

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.

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.

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.