Re: Mixed Case -> Upper Case in Excel?

Article View: comp.sys.mac.apps

Article #9599

#9599

From: Carl Ballard
Date: Wed, 16 Dec 1992 02:10

38 lines
1734 bytes

In article <derosa.724361616@mica> derosa@rtsg.mot.com (John DeRosa) writes:
>Is there a way to convert mixed case characters
>to Upper case in Excel?  I just got done doing it
>but there has *GOT* to be a easier way.
>
>1st Try - I looked around for some menu item that
>would do it in Excel.  Nothing.  Nothing in the 
>manual either under text or case.
>
>2nd Try - select, copy, paste into Word.  Change to all
>upper case.  Select, copy, paste back into Excel.  Reverts
>back to mixed case in Excel!
>
>3rd Try - Save as text from Word.  Open text doc from 
>Excel, still lower case.  Word converts the upper to 
>mixed when saving into text!
>
>4th Try - Look in Edit, Edit II  and Alpha for case
>conversion...none.
>
>5th Try - select, copy, paste into MacDraw!!  Convert
>to upper case.  Select, copy, paste back into Excel.
>OK!!!
>
>Go Figure.  John DeRosa
>-- 
>=  Enjoy!          John DeRosa, Motorola, Inc, ESMR Development  =
>=  thanks          derosa@ssd.comm.mot.com                       =
>=  a 10^6          N1111@applelink.apple.com                     =
>

There is an EXCEL function that does this.  It;s UPPER.

Try:  =UPPER(whatever)

- Carl Ballard
  Ascent Logic Corporation
  e-mail:ballard@alc.com

Technical Details

Message-ID: <1992Dec16.021049.15903@alc.com>

Path: arc1-ca.pugleaf.net!sparky!uunet!usc!cs.utexas.edu!uwm.edu!spool.mu.edu!umn.edu!csus.edu!netcom.com!netcomsv!alc!news

References: <derosa.724361616@mica>

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.mac.apps
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!cs.utexas.edu!uwm.edu!spool.mu.edu!umn.edu!csus.edu!netcom.com!netcomsv!alc!news
From: ballard@alc.com (Carl Ballard)
Subject: Re: Mixed Case -> Upper Case in Excel?
Message-ID: <1992Dec16.021049.15903@alc.com>
Sender: news@alc.com
Nntp-Posting-Host: mac-ballard
Organization: Ascent Logic Corporation
References: <derosa.724361616@mica>
Distribution: na
Date: Wed, 16 Dec 1992 02:10:49 GMT
Lines: 39

Reply to Parent Message