Donate SIGN UP

Removal of Hyperlinks

Avatar Image
Mr-H | 22:04 Sat 24th Jul 2010 | Computers
1 Answers
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?
Gravatar

Answers

Only 1 answerrss feed

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.
My Help function explains it OK. Search for 'hyperlink'

Only 1 answerrss feed

Do you know the answer?

Removal of Hyperlinks

Answer Question >>

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.