Multiple hyperlinks
 

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

Multiple hyperlinks
 

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"
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

Multiple hyperlinks
 

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
editpaste special and select add

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Jim Cone" wrote in message
...
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"
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

Multiple hyperlinks
 

It works great! Thanks Jim :-)

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

Multiple hyperlinks
 

Thanks Peo,

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

Thanks again
Martin