RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet

Subject: RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet
From: "Leonard C. Porrello" <Leonard -dot- Porrello -at- SoleraTec -dot- com>
To: <garrett1 -at- garrettwinn -dot- com>, <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Tue, 23 Sep 2008 11:20:49 -0700

You also might try exporting to CSV format and then re-importing to
Excel format.

Leonard

-----Original Message-----
From: techwr-l-bounces+leonard -dot- porrello=soleratec -dot- com -at- lists -dot- techwr-l -dot- com
[mailto:techwr-l-bounces+leonard -dot- porrello=soleratec -dot- com -at- lists -dot- techwr-l -dot- c
om] On Behalf Of Garrett R. Winn
Sent: Tuesday, September 23, 2008 11:12 AM
To: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: RE: Is there a way to delete ALL hyperlinks in an Excel
spreadsheet

I like to use a program called Pure Text
(http://www.stevemiller.net/puretext/).

I can just select all the cells in the table that I want, do a cut, then
paste over the top using the shortcut key combo I created, and voila, I
have
no hyperlinks.

This is a little quicker (once you have the program installed) than
Dan's
method.

Plus, I use Pure Text all the time when I copy and paste - to remove all
the
formatting junk that usually accompanies the operation.

Much success,

Garrett

-----Original Message-----
From: techwr-l-bounces+garrett1=garrettwinn -dot- com -at- lists -dot- techwr-l -dot- com
[mailto:techwr-l-bounces+garrett1=garrettwinn -dot- com -at- lists -dot- techwr-l -dot- com] On
Behalf Of Hemstreet, Deborah
Sent: Tuesday, September 23, 2008 10:46 AM
To: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: Is there a way to delete ALL hyperlinks in an Excel spreadsheet

Hi all,



Would anyone know if there is a way to delete all hyperlinks in a
spreadsheet, for over 100 cells?



Thanks in advance,



Deborah

One Person DOES Make a Difference

http://www.tech-challenged.com <http://www.tech-challenged.com/> (under
construction)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help gives you everything you need to author and
publish
quality Help, Web, and print content. Perfect for technical authors,
developers, and policy writers. Download a FREE trial.
http://www.componentone.com/DocToHelp/

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as garrett1 -at- garrettwinn -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit
http://lists.techwr-l.com/mailman/options/techwr-l/garrett1%40garrettwin
n.co
m


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help gives you everything you need to author and
publish quality Help, Web, and print content. Perfect for technical
authors, developers, and policy writers. Download a FREE trial.
http://www.componentone.com/DocToHelp/

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as
Leonard -dot- Porrello -at- soleratec -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit
http://lists.techwr-l.com/mailman/options/techwr-l/leonard.porrello%40so
leratec.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help gives you everything you need to author and
publish quality Help, Web, and print content. Perfect for technical
authors, developers, and policy writers. Download a FREE trial.
http://www.componentone.com/DocToHelp/

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.


References:
Is there a way to delete ALL hyperlinks in an Excel spreadsheet: From: Hemstreet, Deborah
RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet: From: Garrett R. Winn

Previous by Author: RE: "and then," or simply "then"?
Next by Author: RE: "and then," or simply "then"?
Previous by Thread: RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet
Next by Thread: FW: Is there a way to delete ALL hyperlinks in an Excel spreadsheet


What this post helpful? Share it with friends and colleagues:


Sponsored Ads