Mar 2 2012

Change Case of Text in Excel

One question I get all the time is how to change the case of text in Excel. Some applications require case-specific text to make a match with its data. Or you may just want to clean up your data to make it consistent across the document.  Excel provides three quick formulas to accomplish the text-case change we are talking about.


Changing the Case of Text in Excel
We’re now going to look at three formulas that can change the case of text in Excel, PROPER, UPPER & LOWER. For our examples, we will assume cell A1 contains the text “excel FORMULAS”.

=PROPER(A1) will return “Excel Formulas”

=UPPER(A1) will return “EXCEL FORMULAS”

=LOWER(A1) will return “excel formulas”

It’s that easy.  Just add this formula to an adjacent cell in Excel and watch your text’s case be instantly updated without manually changing each cell.

Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          
TAGS:

4 Comments on this post

Trackbacks

  1. Guy said:

    You probably want to fix the data in the original column.
    so copy the calculated column.
    Move to the orginal column.
    Then right click PASTE OPTIONS / VALUES
    This will replace the mis formatted data with the refoarmatted data.
    Lastly delete or erase your formula column.

    March 5th, 2012 at 9:36 am
  2. john said:

    Thanks Guy, good suggestion.

    March 5th, 2012 at 11:14 am
  3. Jim said:

    Very good tip Guy will try that does it also work in excel 2010?

    April 5th, 2013 at 1:28 pm
  4. Manfred said:

    @Jim, yes COPY / PASTE Special – Values works everywhere

    June 27th, 2013 at 7:13 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives