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

["Leonard C. Porrello" <Leonard -dot- Porrello -at- SoleraTec -dot- com>]

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.