Re: Excel cell content
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.'
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).
Kat Nagel, MasterWork Consulting
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.
- Re: Excel cell content, Kat Nagel
Excel cell content: From: Szul, Andy C Mr WRAMC-Wash DC
Visit TechWhirl's Other Sites