Posted to microsoft.public.excel.programming

Graham H

external usenet poster

Posts: 56

Remove hyperlinks

I have downloaded a lot of text from a site and most of it is in hyperlinks, but I just
want the text. Is there a quick way to remove all the hyperlinks in a worksheet or
workbook. I appreciate I could loop round all the cells but there is a lot of material and
I just wondered if there was something simpler. I would value any help.

Regards
Graham

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove Hyperlinks	Jester	Links and Linking in Excel	2	June 5th 10 03:46 AM
Trying to remove hyperlinks	Carrguy	Excel Programming	1	September 9th 06 09:02 PM
Remove Hyperlinks	dthmtlgod	Excel Programming	3	December 29th 05 01:00 PM
remove all hyperlinks	ski2004_2005	Excel Programming	1	June 8th 05 07:40 PM
How do I remove hyperlinks	westy	Excel Discussion (Misc queries)	1	March 20th 05 12:05 AM

All times are GMT +1. The time now is 02:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us