Re: Excel question

Subject: Re: Excel question
From: John Posada <jposada01 -at- yahoo -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Tue, 7 Nov 2000 10:12:18 -0800 (PST)

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.


Previous by Author: Re: Books on Writing Functional Specifications
Next by Author: RE: Excel question
Previous by Thread: Excel question
Next by Thread: RE: Excel question


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


Sponsored Ads