Re: Reversing word order in Excel 2007 cells

Subject: Re: Reversing word order in Excel 2007 cells
From: Chris Morton <salt -dot- morton -at- gmail -dot- com>
To: techwr-l -at- lists -dot- techwr-l -dot- com
Date: Mon, 12 Apr 2010 09:08:29 -0700

I'd use the string manipulation capablities (*Str*<*action*>) of
WinBatch<http://www.winbatch.com/>,
for which there is also an excellent user forum. There would have to be
either be a set pattern on which to base the macro, or else the specific
fields that require massaging would have to be identified to the macro
somehow.

Once the fields are known, the routine can easily juxtapose two words in any
cell, provided that's the pattern. Consider:

cat dog

Would now become:

dog cat *--or--* dog, cat (if you specify the comma insertion)

But if you have:

cat dog bird

the macro would need to know how to deal with that, too. One way is to have
the macro count the words in a given cell (using each space as a delimiter),
then manipulate the words in the order you so specify. Again, you need a
establish a desired pattern ahead of time that you would like the macro to
follow.

Contact me offline, if you'd like, to learn more about how you might tackle
this problem.

> Chris
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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-

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.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


References:
Reversing word order in Excel 2007 cells: From: Ken Poshedly

Previous by Author: Re: RE: Technical Writer Certification
Next by Author: Re: File and Folder diff utility
Previous by Thread: Reversing word order in Excel 2007 cells
Next by Thread: RE: Reversing word order in Excel 2007 cells


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

Sponsored Ads


Sponsored Ads