Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emece
 
Posts: n/a
Default Hyperlinks

I am importing data from a web page into an excel worksheet. This data
contains hyperlinks, when I paste it in Excel I want to copy only the text,
not the hyperlinks. How can I do this? I tried the Paste Special Options, but
HTML keeps the hyperlinks, and plain text looses the format.

Thanks in advance

Regards
Emece.-
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Losing hyperlinks RedChip Excel Discussion (Misc queries) 0 November 30th 05 10:56 AM
Picture hyperlinks don't work when publishing to web...? norders Excel Discussion (Misc queries) 0 November 25th 05 01:29 PM
Hyperlinks and renaming tabs woolyhedgehog Excel Discussion (Misc queries) 0 October 18th 05 06:04 PM
Hyperlinks and sorting data Rena Excel Discussion (Misc queries) 0 June 3rd 05 07:50 PM
up-date hyperlinks in Excel PM Excel Worksheet Functions 0 November 11th 04 11:55 AM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"