Re: Reversing word order in Excel 2007 cells

[Chris Morton <salt -dot- morton -at- gmail -dot- com>]

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