Multiple hyperlinks

[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

[Jim Cone]

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

[Peo Sjoblom]

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




"Jim Cone" <[email protected]> wrote in message
news:%[email protected]...
> 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

[MartinW]

It works great! Thanks Jim :-)

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

[MartinW]

Thanks Peo,

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

Thanks again
Martin