Removing Hyperlinks

  • Thread starter Thread starter Gee...
  • Start date Start date
G

Gee...

I have a spreadsheet that has 1,959 rows and 2 hyperlinks
per row. I didn't make this mess but I need to delete all
the hyperlinks. Is there a way to remove them all at
once? I tried Edit>Links but Links is not available.
Thank you in advance for your help.
Gee...
 
It won't let me in...it's saying this:

Warning: mysql_pconnect(): Access denied for
user: 'excelfor_excelvb__@localhost' (Using password: YES)
in /home/excelfor/public_html/admin/db_mysql.php on line 38
 
I've figured it out...if anyone is wondering how:
Type 1 in a cell, copy it, highlight all the cells with
hyperlinks to remove in them, Edit, Paste Special,
Multiply. That will remove the links without changing the
cell value.
 
Back
Top