Re: Excel question

[John Posada <jposada01 -at- yahoo -dot- com>]

You need to do it in a formula...there isn't a keyboard shortcut:

UPPER
Converts text to uppercase.
Syntax = UPPER(text)

Text is the text you want converted to uppercase. Text can be a
reference or text string.

Examples

UPPER("total") equals "TOTAL"
If E5 contains "yield", then: 
UPPER(E5) equals "YIELD"

Example:
If cell A1 is Posada and I want to change it to POSADA, I enter the
following formula:

=UPPER("Posada"


--- Jean Cooper <Jean -dot- Cooper -at- twtelecom -dot- com> wrote:
> I hope this is an easy question:
> 
> 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. 


=====
John Posada
Senior Technical Writer, in process of looking
for next contract effective 1/1/2001.
"As I would not be a slave, so I would not be a master."
               -Abraham Lincoln
mailto:john -at- tdandw -dot- com, 732-259-2874

__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Learn how to develop HTML-based Help with Macromedia Dreamweaver!
Dec. 7-8, 2000, Orlando, FL -- $100 discount for STC members.
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.