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.
I have been lurking on the list for a month or two. I'm in the process of
expanding my existing research and technical consulting company to include
technical writing and training services.
I have noticed a few questions about trying to do things in Excel that are
easy to do in Word. Usually, the easiest way to do that is to either:
1) Do what you have to do in a Word table, then link that table to your
Excel document; or
2) Do what you have to do in a Word table then copy and paste into Excel.
For example, on Tuesday Jean Cooper asked:
"How can I change a column of text data from lowercase to all-caps? (Other
than re-typing it, of course.) I know in Word you just highlight the
selection and then hit Shift-F3. But I can't find any way of doing it in
Excel."
The Excel "UPPER" function works perfectly in this case.
An alternative method is to:
1) copy the column of lower case text,
2) open and paste that column into Word,
3) change the format, then
4) paste that text back over her original.
I found that in that case the text returned to lower case unless I used the
"Paste Special" rather than plain paste, and chose "Paste as Text".
I mention this because I have often wanted to do more complicated formatting
changes in excel, for which the built in formatting functions would become
unwieldy. I have found that pretty much any format that can be achieved in a
Word table can be displayed in Excel. Sometimes it takes a few attempts
using the different paste or "paste special" options.
Hope this helps some people,
John Hollinrake
Edmonton, Alberta
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Develop HTML-based Help with Macromedia Dreamweaver! (STC Discount.)
**NEW DATE/LOCATION!** January 16-17, 2001, New York, NY. http://www.weisner.com/training/dreamweaver_help.htm or 800-646-9989.
Sponsored by SOLUTIONS, Conferences and Seminars for Communicators
Publications Management Clinic, TECH*COMM 2001 Conference, and more http://www.SolutionsEvents.com or 800-448-4230
---
You are currently subscribed to techwr-l as: archive -at- raycomm -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.
