| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Hyperlink into URL
hey guys... I have a long single-column sheet of urls which are displayed as
friendly_name hyperlinks (blue & underlined) what I need are the link_location url addresses instead I tried copy then paste special but no luck and the command remove hyperlink simply converts the hyperlink into text and loses the url all together any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Hyperlink to cell value automatically | Excel Worksheet Functions | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| How to convert a hyperlink to its target full-text URL | Excel Discussion (Misc queries) | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
