TURN LOWER CASE TO UPPER CASE IN EXCEL?

G

Guest

Help tries to explain how to turn lower case to upper case but fails miserably!
Can someone walk me through it?
 
C

Carlos Antenna

If the lower case text is in A1, type this formula in B1 =UPPER(A1).

-- Carlos
 
G

Gord Dibben

Tommy

Help says to enter a formula in a cell referring to another cell.

i.e. A1 contain tommy

In B1 enter =UPPER(A1)

If you more than A1 with lower case, you can drag/copy the formula from B1
down column A.

To drag/copy, hover the mouse pointer over the bottom right corner of B1 until
you see a black cross. Click on that and drag down the column.

=UPPER(A1) will change to =UPPER(A2) then =UPPER(A3) etc.

When happy with the results, copy the cells with the formula then Edit>Paste
Special(in place)>Values>OK>Esc.


Gord Dibben 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

Lower-Case Characters 2
Upper case to Lower case 5
filtering to separate upper & lower case 5
Change lower case to upper case 6
Upper Case vs. Lower Case Add-Ins 5
upper case letters 4
Upper case to Lower case 7
change lower-case to upper-case 3

Top