changing the case of typed information

  • Thread starter Thread starter Malley
  • Start date Start date
M

Malley

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
 
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
special>values>ok>esc.


Gord Dibben MS Excel MVP
 
Back
Top