Removing hyperlinks in Excel by multiplying by 1 is very obtuse

[Guest]

I just followed the Excel help directions for "Remove a hyperlink" ->
"Deactivate several hyperlinks at once". And while the directions work
(multiplying each field by 1), they strike me an obscure work around to a
rather obvious missing feature. It should be easy to remove hyperlinks from
text in Excel, especially because Excel is very agressive about auto-creating
hyperlinks when any text that resembles a web address is entered. Hopefully
this missing feature will be addressed in the next verison of Excel.

 

[Frank Kabel]

Hi
post your suggestion to:
(e-mail address removed)

 

[Dave Peterson]

In xl2002 (not quite the newest Windows version), you can do this:

Tools|autocorrect options|autoformat as you type tab
uncheck internet and network paths with hyperlinks.

An alternative:
hit ctrl-a (twice in xl2003)
hit alt-f11 to go to the VBE
hit ctrl-g to see the immediate window
type this in and hit enter.
selection.hyperlinks.delete
then alt-f11 back to excel

(Just select a range if you don't want to do the complete sheet.)