Thread: http to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default http to text

George

Have you tried Copy/Paste Special... Values?

HTH
Kostis Vezerides

George W. Barrowcliff wrote:
I copied the XM radio channel lineup to excel and the displayed information
is something like

The '60s*

But the cell actually has the http://etc etc etc to take you back to the XM
radio site. I would like to strip all the url data from the cell and just
leave the text display. Pasting into notepad gets rid of the url data but
leaves everything all run together.

Thanks in Advance, GWB