Hey Guys -
I'm using Excel 2016 and have got a spreadsheet in the following format:
----------A-------------B-----------C------------D---------------E-----------------F
1----Tool Name----Category---License----Overview------How To Use-------Web URL
2------Ditto--------Desktop-----Open-----Blah, Blah------Blah, Blah--------www ditto com
3...
Notes:
- Row 1 values are just column headers
- Please ignore the dashes. Spacing wasn't translating correctly so added them in for that purpose only
- Cell F2 should be a standard HTTP web URL, but I can't post them yet
As you can see, Column A is a name and column F is a web URL. The goal is to create a formula or other method which will grab the address from column F and set is as the hyperlink for the text in Column A. Once done, I will be deleting column F as the purpose of this is to clean up the spreadsheet. If applied to the example above, the end result would look similar except for "Ditto" would be hyperlinked to go to "www ditto com" when clicked on and column F would no longer exist thus making row 2 appear as follows:
----------A-------------B-----------C------------D---------------E
1----Tool Name----Category---License----Overview------How To Use
2------Ditto--------Desktop-----Open-----Blah, Blah------Blah, Blah
3...
"Ditto" in cell A2 above would be hyperlinked to the value that was in cell F2 (www ditto com)
I have tried a few things out and the furthest I got was in a cell in column G (empty) adding the formula: "=HYPERLINK(F2, A2)". This would create the text named after cell A2 in that column with a hyperlink from F2 as desired except that it's in cell G2, not A2 and it references other cells which I plan to delete. I tried copying the cell then pasting it into A2 using a variety of "special" pastes, but nothing I found could do what I wanted. I'm only applying this to 2-3 spreadsheets so am planning to delete the column manually.
Overall, I think it would work if I could just find out a way to copy one cell to another which would retain the cell's text, retain it's hyperlink, and not be dependent on any other cells for it's values.
Any suggestions? Thanks!
Bookmarks