Thread: Hyperlinks
View Single Post
  #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.-