I have a spreadsheet with lots of formatting. One column has email
addresses. In the course of using this data, the rows have been sorted, new
rows and/or columns have been inserted, etc. The original hyperlink stays
embedded in the original cell. I know how to deactivate a hyperlink (right
click, delete hyperlink) when it is that alone in the cell but when text is
now in that column due to data being moved, how do I delete the hyperlink
that is attached to cells. Example:
John Doe is in 2B and the email hyperlink is in 2C. The data gets sorted
differently and perhaps the email address is moved to 3C. When you look at
the spreadsheet you see John Doe in 3C but when you put your cursor on 3C,
the original hyperlink that was in 3C (Jane Smith) is still there.

If you're going to keep the email addresses in one column, you could use a
worksheet function in the adjacent column that provides the hyperlink.

Depending on what's in A1, you could use this kind of thing in B1:

=hyperlink("mailto:" & a1,a1)





Rosemary Hopkins wrote:

I have a spreadsheet with lots of formatting. One column has email
addresses. In the course of using this data, the rows have been sorted, new
rows and/or columns have been inserted, etc. The original hyperlink stays
embedded in the original cell. I know how to deactivate a hyperlink (right
click, delete hyperlink) when it is that alone in the cell but when text is
now in that column due to data being moved, how do I delete the hyperlink
that is attached to cells. Example:
John Doe is in 2B and the email hyperlink is in 2C. The data gets sorted
differently and perhaps the email address is moved to 3C. When you look at
the spreadsheet you see John Doe in 3C but when you put your cursor on 3C,
the original hyperlink that was in 3C (Jane Smith) is still there.

--

Dave Peterson