| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Hyperlink formulae to real hyperlink
Hi there, I have the following formulae =HYPERLINK("mailto:"&J2,A2) which creates a working hyperlink. Problem is I need to move this data to another spreadsheet - If I copy and paste values it looses the hyperlinking abilities... question How can I take this hyperlinked formulae and paste it as a value (ie that does not refer to the other cells), but still works as a hyperlink... Regards D *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting hyperlink to actual web address | Excel Discussion (Misc queries) | |||
| How do you keep a hyperlink active after converting to a PDF? | Excel Discussion (Misc queries) | |||
| hyperlink between sheets not working after converting to pdf | Excel Discussion (Misc queries) | |||
| Converting Text to a hyperlink | Excel Programming | |||
| converting hyperlink paths | Excel Discussion (Misc queries) | |||
Threaded Mode
