Pasting HTTP 'without' it being a clickable link??
I copied some test which included some URLS in it. When I past it I
noticed the URLS were clickable which I wanted the URLS to be just plain text like the rest of the clipboard data. How can I remove URL's link-a-bility without deleting the actual text portion of the URL in EXCEL 97? |
Pasting HTTP 'without' it being a clickable link??
Robert,
Press Ctrl-Z after the paste to remove the hyperlink. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message ... I copied some test which included some URLS in it. When I past it I noticed the URLS were clickable which I wanted the URLS to be just plain text like the rest of the clipboard data. How can I remove URL's link-a-bility without deleting the actual text portion of the URL in EXCEL 97? |
Pasting HTTP 'without' it being a clickable link??
.... and if you want to disable the featu
Tools/ AutoCorrect Options/ AutoFormat As You Type/ disable "Internet and network paths with hyperlinks". -- David Biddulph "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Robert, Press Ctrl-Z after the paste to remove the hyperlink. HTH, Bernie MS Excel MVP "Robert Blass" wrote in message ... I copied some test which included some URLS in it. When I past it I noticed the URLS were clickable which I wanted the URLS to be just plain text like the rest of the clipboard data. How can I remove URL's link-a-bility without deleting the actual text portion of the URL in EXCEL 97? |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com