Excel questions

Subject: Excel questions
From: "John Hollinrake" <john_h -at- telusplanet -dot- net>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Thu, 9 Nov 2000 03:56:36 -0700


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

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.

Previous by Author: RE: Rotating an inserted Excel file in Word
Next by Author: RE: Microsoft press computer dictionary
Previous by Thread: Re: Genre (was Re: Need help with a research project)
Next by Thread: RE: fair "atmospheric" benefits

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

Sponsored Ads

Sponsored Ads