Converting Lower case text to upper case

T

tomstpete

I can't figure out how to change the text in a spread sheet to uppercase. In the Help feature, I can find the function "uppercase" but no instruction as to how to use it.
 
C

CyberTaz

If you mean you want to*globally* convert all text in a sheet to Upper Case,
I don't know of a way to do so in Mac XL.

The UPPER function is more for displaying the content of referenced cells in
upper case regardless of how it was typed into the cells where it is
actually stored.

If the latter is what you are trying to do, see Excel Help on the UPPER
function, but it's rather straightforward...

If cell A1 contains the word [help] or [Help] (or any variation on case for
that matter) and in cell B1 you put:

=UPPER(A1)

Cell B1 will display [HELP]

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
B

Bob Greenblatt

I can't figure out how to change the text in a spread sheet to uppercase. In
the Help feature, I can find the function "uppercase" but no instruction as to
how to use it.
Click to expand...
Upper changes the contents of the cell it resides in. So, if A1 has lower
case text and you enter the formula =upper(a1) in D1, then D1 will contain
the upper case version of the text in A1. To actually change the text in A1
to upper case, copy D1, then Select A1, and select edit-paste Special, and
select Values.
 
J

John Grunberg

The only way I can make either a column or worksheet into uppercase is to copy it into word, use the word "format" command and do a gobal change, then copy the changed worksheet/column into excel using special paste "text".

If anyone else has a better method let me know as this way is a "crock"!!

regards

John Grunberg
 
H

Harvey Waxman

The only way I can make either a column or worksheet into uppercase is to
copy it into word, use the word "format" command and do a gobal change, then
copy the changed worksheet/column into excel using special paste "text".

If anyone else has a better method let me know as this way is a "crock"!!

regards

John Grunberg
Click to expand...

There is a "capitals" font that might work.
 
T

tomstpete

John, you're a genius. Who'da thunkit!
I have several all caps fonts, any one of which works fine.
Tom
 
Top