I need to correct errors in quite a few e-mail addresses in my church membership spreadsheet, but they are all hyperlinks. Firstly, it seems next to impossible to remove a hyperlink once it is added, which fact makes it impossible to edit typos. Furthermore, I really, really do not wish to create more errors in the data by re-typing the addresses completely.
If that is really what I have to do, however, then I will do it, but how then do I make future corrections easier by preventing the text from being hyperlinked again? I see no option in Tools > Options for disabling automatic hyperlinking. So, tell me: what’s the trick?
I am aware that Ctrl + K will insert a hyperlink, but the dialogue window that pops up shows no way to remove a hyperlink. If there is a command to remove a hyperlink after it has been created, where is it? Also, how can I remove hyperlinks from a block of cells?