TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:RE: Reversing word order in Excel 2007 cells From:"Combs, Richard" <richard -dot- combs -at- Polycom -dot- com> To:'Peter Neilson' <neilson -at- windstream -dot- net> Date:Mon, 12 Apr 2010 12:33:22 -0700
Peter Neilson wrote:
> Richard Combs wrote:
>
> > Sorry, but there's simply no way to automate this.
>
> I'd output to a csv file and write emacs macros to do the correction,
> then re-import the csv. It'd be worth it to find someone who already has
> emacs built into his fingers. (I'm one, of course, but there are
> others.) The "programming" in emacs is trivial. Well, "trivial".
Judging from the examples Ken provided, there doesn't seem to be enough regularity of the data to permit a programmatic solution. A human has to look at the contents of each cell and decide what result is desired.
That said, I'm sure someone with "emacs built into his fingers" could do that and make the necessary changes much faster than someone manually selecting, cutting, pasting, etc., in Excel. :-)
Richard G. Combs
Senior Technical Writer
Polycom, Inc.
richardDOTcombs AT polycomDOTcom
303-223-5111
------
rgcombs AT gmailDOTcom
303-903-6372
------
Use Doc-To-Help's XML-based editor, Microsoft Word, or HTML and
produce desktop, Web, or print deliverables. Just write (or import)
and Doc-To-Help does the rest. Free trial: http://www.doctohelp.com
Explore CAREER options and paths related to Technical Writing,
learn to create SOFTWARE REQUIREMENTS documents, and
get tips on FUNCTIONAL SPECIFICATION best practices. Free at: http://www.ModernAnalyst.com
---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-