If e.g. a cell has the function =+HYPERLINK("http://www.excelforum.com";"Excel Forum"), I want to copy this cell to an other cell which has only the name "Excel Forum", which act as usaully, that means click on the name will move you to that hyperlink.
I did a lot of reading for a solution by means of Google and found only one, the same as I found allready myself:
- Copy the original cell and paste it in a Word document. There you find the hyperlink form as I want. Then copy this hyperlink back to Excell and ready.
But that must be possible without using Word as immediate. But How?