Remove Hyperlinks in Microsoft Excel
Sure, you can use a macro if you do this on a regular basis.
to learn how from Excel MVP J. E. McGimpsey. Thanks to Dave McRitchie for
pointing it out for us.
Excel 2000 and Below
Manually, you can copy, open Word, EditŕPaste
Special as unformatted text, then copy back.
Microsoft has to say about preventing their creation.
Excel 2002 and Above
If you just need to do this from time to time, select the
cells and copy them. Don't move your cursor! Hit EditŕPaste
Special, choose Values, and hit OK.
Each method removes the underlying hyperlink, but not the text.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved