Re: Excel cell content

Subject: Re: Excel cell content
From: Kat Nagel <mlists -at- masterworkconsulting -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Tue, 15 Jun 2004 17:58:40 -0400


At 10:57 AM -0400 2004/06/14, Szul, Andy C Mr WRAMC-Wash DC wrote:

I've got "Jones -at- 34 -dot- 15" in a cell and Excel insists it's an email addy. When I place my cursor over that cell, and click, my email program opens with "Jones -at- 34 -dot- 15" as the recipient.


I just struggled with this particular Word annoyance for an hour today.

The answer, believe it or not, is in the online help. Search for the keyword 'hyperlink' and tunnel your way down to an option called something like 'Remove one or more hyperlinks from your data cells.'

WARNING!
The procedure (multiply a hyperlink by 1 and paste the result back in the problem cell---HUH?!?) makes no sense at all, but it works. Saved my neck by allowing me to meet a deadline with a well-behaved spreadsheet (even if it didn't help bolster my delusions of sanity).

--
K@
Kat Nagel, MasterWork Consulting
http://www.masterworkconsulting.com

585.820.4045
katnagel -at- masterworkconsulting -dot- com

.

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

SEE THE ALL NEW ROBOHELP X5 IN ACTION: RoboHelp X5 is a giant leap forward
in Help authoring technology, featuring Word 2003 support, Content Management, Multi-Author support, PDF and XML support and much more! http://www.macromedia.com/go/techwrldemo
COMPONENTONE DOC-TO-HELP 7 PROFESSIONAL: From a single set of Word documents, create online Help and printed documentation. New version offers yearly subscription service, Natural Search, Modular TOC Utility, Image Map Editor, Theme Designer, Context String Editor, plus more. http://www.componentone.com/doctohelp .

---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit
http://www.raycomm.com/techwhirl/ for more resources and info.



Follow-Ups:

References:
Excel cell content: From: Szul, Andy C Mr WRAMC-Wash DC

Previous by Author: Re: How to set up a listserve?
Next by Author: Re: Excel cell content
Previous by Thread: Excel cell content
Next by Thread: Re: Excel cell content


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

Sponsored Ads


Sponsored Ads