UPPER, lower, Proper

I am wondering why these functions are not available in Word, but Excel?

Don’t make me wrong.  I like these functions.  Nevertheless I am not a big fan (nor a small fan) of using Excel as word processor.  Whenever possible, use Excel to handle data; Word to handle words.  That are what the softwares designed for!?

But the fact is, many people use Excel in their own ways and can somehow create forms and documents with Excel even better than they do the same in Word.  Agree?   I would say: Excel is so great that it handles not just numbers but texts equally effective.

Well, too much personal talks… let’s go back to the subject: UPPER, lower, Proper.

The syntax is simple.

=UPPER(text) 'change all letters to UPPER CASE

=LOWER(text) 'change all letters to lower case

=PROPER(text) 'Capitalize the first letter of each word in a text string.

All of them require only one argument.  The argument could be a direct text enclosed with “”, a reference, or a formula result.  They are quite easy to follow.  Nevertheless, he meaning of “each word” described above for PROPER is a bit tricky.  It means the first word and any word that follow any character other than a letter.

Again and again, a picture tells more:Excel Tips - UPPER_LOWER_PROPER.png

As simple as that.🙂

How to do the same in Word?

To capitalize all letters is easy in Word.  Just select the texts you want to capitalize, right click–> Font–> Check the “All caps”.

Here’s an example:Excel Tips - All Upper Case

Wait… How to do lower and Proper in Word?

Honestly, I don’t know…

If you know, please share in comments.🙂

This entry was posted in Formula and tagged , , . Bookmark the permalink.

8 Responses to UPPER, lower, Proper

  1. MF says:

    Thank you all for enlightening me!🙂


  2. Dan Erel says:

    in word you use Shift+F3 to change from Lower > Upper > First latter


  3. MF says:

    Thanks gentlemen! I learn something new today.🙂


  4. Graham says:

    In Word (2010) Use “Change Case” on the Home Tab


    • Omar says:

      I don’t see that choice in 2013 or 2016 on the Home tab. I had to add it to the Quick Access toolbar from the commands not in the ribbon.

      There are two choices of commands. Change Case.. (with three dots) and Change Text Case (without the dots). Change Text Case will cycle through lower, UPPER and Sentence. Change Case… gives you a menu with radio buttons and includes Proper. Proper acts different than described above, though.


  5. Sabine says:

    Hello MF,
    I’m working with Office Professional 2003, german version.
    In Word you can do the following:

    Format -> Groß-/Kleinschreibung

    If you don’t have got “Groß-/Kleinschreibung” in your menue, choose Extras -> Anpassen -> Befehle -> Kategorie Format on the left side -> scroll down until you find “Groß-/Kleinschreibung”
    and put it into the Format Menue.

    All you then have to do is to mark the text you would like to change and then click on Format -> Groß-/Kleinschreibung and choose your option (UPPER, lower, Proper, first letter upper at the beginning of the sentence, first letter low and the followings upper) .

    In newer versions try to look under File -> Options, if you don’t find it under Tools.

    In Libre Office 5.1.4 it’s a little bit easier. Open Writer -> Format -> Text -> Groß-/Kleinschreibung

    Groß-/Kleinschreibung = Upper/lower
    Extra = Tools in english version

    Hope that helps
    Have a nice weekend
    LG Sabine from Germany


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s