Excel - copy the URL of a hyperlink
Solved
Azrevgoo
Posted messages
2
Status
Membre
-
GrandChacal -
GrandChacal -
Hello,
I'm sorry if this question has already been asked, but while searching I couldn't find an answer to my question, so I'm creating this post:
I need to know if it's possible to copy and transfer only the hyperlink associated with text from one cell to an adjacent cell, not the text. The thing is, I have about a hundred links to copy, so I'm looking for a faster way than copying/pasting each link one by one.
For example:
in cell A1, I have "google" with a hyperlink to google.com, and I would like to transfer only google.com to A2
Can someone help me?
Thank you in advance, and have a great day!
Configuration: Windows 7 / Firefox 14.0.1
I'm sorry if this question has already been asked, but while searching I couldn't find an answer to my question, so I'm creating this post:
I need to know if it's possible to copy and transfer only the hyperlink associated with text from one cell to an adjacent cell, not the text. The thing is, I have about a hundred links to copy, so I'm looking for a faster way than copying/pasting each link one by one.
For example:
in cell A1, I have "google" with a hyperlink to google.com, and I would like to transfer only google.com to A2
Can someone help me?
Thank you in advance, and have a great day!
Configuration: Windows 7 / Firefox 14.0.1
