Editor's Blog4 mins ago
Removal of Hyperlinks
A friend gave me a copy of an Excel spreadsheet which has over 150 hyperlinks to files contained within HIS own PC. Of course, these are no good to me and I want to delete the link, but keep the contents of the cell. Excel 'help' says to Clear Contents, or Delete the cell, but this would mean I would then need to re-enter what is already there. Is there any alternative, preferably to delete all 150 Hyperlinks 'en bloc', using just one all-embracing command, or something similar. Any ideas?
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by Mr-H. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.