I've got this situation:
-|____A___|_________________B________________|_____C______|______D_____| 1| Title1 | =HYPERLINK($C$1 & A1 & $D$1; A1) | URL Part 1 | URL Part 2 | 2| Title2 | =HYPERLINK($C$1 & A2 & $D$1; A2) | | |
This causes the B cells, in this case, to have working hyperlinks to the complete URL with the titles in the A cells. Now, what I want to do is replace the A cells with the B cell. This is, of course, a problem though as the HYPERLINK function in the B cells are dependent on the A cells that I want to replace. This is the result I'm looking for:
-|_____________________A____________________|_B_|_____C______|______D_____| 1| =HYPERLINK($C$1 & Title1 & $D$1; Title1) | | URL Part 1 | URL Part 2 | 2| =HYPERLINK($C$1 & Title2 & $D$1; Title2) | | | |
-|___________________A_______________| 1| =HYPERLINK(Complete link; Title1) | 2| =HYPERLINK(Complete link; Title2) |
This wouldn't be a big issue if it was just these two rows but I have over 50 rows like this so a quicker method would be preferred.