How do I copy hyperlink only (and not text) to another cell?
- by OfficeLackey
I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across to a different column which has different text in and no hyperlinks.
Not every cell in column A has a hyperlink. There are groups of cells merged…
