If I typed a sentence as lower case, is there a way to change the sentence to
upper case without having to retype it? I've tried the UPPER function but
I'm either not doing it the right way or it just capitilizes anything new
that is typed but doesn't change what already exists in lower case.

Malley,

UPPER should work for you so try this with your lower case text in A1

=UPPER(a1)

Mike

"Malley" wrote:

If I typed a sentence as lower case, is there a way to change the sentence to
upper case without having to retype it? I've tried the UPPER function but
I'm either not doing it the right way or it just capitilizes anything new
that is typed but doesn't change what already exists in lower case.

If the sentence is in A1, then in B1 =UPPER(A1) will do it.

Tyro

"Malley" wrote in message
...
If I typed a sentence as lower case, is there a way to change the sentence
to
upper case without having to retype it? I've tried the UPPER function but
I'm either not doing it the right way or it just capitilizes anything new
that is typed but doesn't change what already exists in lower case.

The UPPER function must be entered in a helper cell.

i.e. in A1 we have the text in lower case.

In B1 enter =UPPER(A1) to return the text from A1 in upper case.

When happy with this, you can copy B1 and select A1 and paste
specialvaluesokesc.


Gord Dibben MS Excel MVP



On Wed, 20 Feb 2008 13:26:04 -0800, Malley
wrote:

If I typed a sentence as lower case, is there a way to change the sentence to
upper case without having to retype it? I've tried the UPPER function but
I'm either not doing it the right way or it just capitilizes anything new
that is typed but doesn't change what already exists in lower case.