changing the case of typed information

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.
 
M

Mike H

Malley,

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

=UPPER(a1)

Mike
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word doc keeps changing to ALL CAPS 0
Changing language for spell check not working? 1
Word isn't capitalizing the first word of each sentence 2
Lower-Case Characters 2
changing lower to upper case issue 1
Caps Lock vs Lower Case 5
Unclear change tracking process 0
How to change sentence in Caps to upper & lower case 3

Top