Unlike microsoft word, Excel does not have an option wherein you could Format text to change case. But don’t worry, excel does have “change case” functions, so in case you have incorrectly typed everything in one case than another, you won’t need to rekey them.
To change case you can use upper, lower or proper formula.
Upper would change everything to upper case. Similarly lower would put them in lower case.Proper case would capitalise the first letter, keeping the rest in lower case.

Suppose you wish to change the contents of column A to lower case instead of upper, you can do that as follows:

change-case.JPG

Share This

Popularity: 10%



Reader's Comments

  1. Willy Marlian | July 29th, 2008 at 7:27 am

    How about Title Case? I have’t found it in any formula. At the moment, I copy-paste selected data to Ms. Word 2003, changing it by “Format, Change Case, Title Case” and then copy-paste again to Excel, not so practice huh?! =(

  2. Shikha | September 14th, 2008 at 7:29 pm

    Hi,
    If you read the last line of our post, you can use “Proper Case” for changing the case to a word having its first letter as a majuscule.
    Regards

  3. Atul | July 4th, 2009 at 7:48 am

    Once again thanks for this tip :)

Leave a Comment

Close
E-mail It