Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I modify a Hyperlink with a function?
I have a column of several thousand cells that have different hyperlinks in each one. I would like to set up a column adjacent to this column and have the hyperlink address in this new column. I have found that there is not a paste special function that will do this and the excel "CELL" function does not work either - although it should. Any suggestions? a VBA solution would be just fine as well. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#2
|
|||
|
|||
I am able to simply copy/paste a cell with a link and the link appears in the new location. Try it. Right click on the link, select Copy. Select your new location, right click, Paste. Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#3
|
|||
|
|||
Does not work. I am not trying to duplicate a hyperlink. My cell has the text "Yahoo" in it and the hyperlink address is "http://www.yahoo.com". I want to put the "http://www.yahoo.com" in the text of the cell adjacent to the original cell and I do not want to have to modify the hyperlink manually to do so. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#4
|
|||
|
|||
copy, edit, paste as hyperlink, if that does not work, try edit, paste special, values -- badpuppie ------------------------------------------------------------------------ badpuppie's Profile: http://www.excelforum.com/member.php...o&userid=15453 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#5
|
|||
|
|||
that does not work. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#6
|
|||
|
|||
odd, it works on mine, perhaps try text to columns, then the same thing -- badpuppie ------------------------------------------------------------------------ badpuppie's Profile: http://www.excelforum.com/member.php...o&userid=15453 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
#7
|
|||
|
|||
You are able to copy a cell that has a hyperlink and paste the target location of the hyperlink with the edit paste special values? When I do that it simply pastes the display text and not the hyperlink address. I want the hyperlink address. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
hyperlink function | Excel Worksheet Functions |