Multiple hyperlinks

  • Thread starter Thread starter MartinW
  • Start date Start date
M

MartinW

Hi group,

How do I delete multiple hyperlinks and retain the text. At present I am
right clicking each hyperlink and going to remove hyperlink which is
painstakingly slow. Any help would be much appreciated.

Thanks
Martin
 
You will have to use a macro or...
The free Excel add-in "Excel Extras" does that and other nice stuff.
It comes with a Word.doc install/use file.
Download from http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"MartinW" <[email protected]>
wrote in message...
Hi group,
How do I delete multiple hyperlinks and retain the text. At present I am
right clicking each hyperlink and going to remove hyperlink which is
painstakingly slow. Any help would be much appreciated.
Thanks
Martin
 
Another way would be to copy an empty cell, select the range with the
hyperlinks (preferably using the name box or the arrow keys) then do
edit>paste special and select add

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
It works great! Thanks Jim :-)

When I get more time I'll go back and check out your site more thoroughly.
 
Thanks Peo,

That works great too! Although I'll have to do a fair bit of studying to
work out how.

Thanks again
Martin
 
Back
Top