Changing case in Excel

Changing case in Excel

  • Comments 2
  • Likes

If you had to choose a program to use for changing case (UPPERCASE, lowercase, Sentence case, etc.) Microsoft Word works best in most cases. It has several options available, and the changes you make are retained if you copy and paste them.

But Excel can be useful at this task too, if you understand how it works. Not only will it save you time, it eliminates the chance that you'll introduce a mistake by retyping the text. This can be particularly helpful if you ever need to change the case of text in a language you don't know; all of the accents and other diacritical marks are retained.

If your text is in a cell, you can use simple formulas to convert it to ALL UPPERCASE, all lowercase, and Proper Case (All Words Start With A Capital).

=UPPER(A1)

=LOWER(A1)

=PROPER(A1)

Here's an example of these three functions in action:

Changing case using functions in Excel

The text returned by these formulas will be retained if you cut and paste the strings into another program, but you'll still have the text you started with in the original cell (A1 in the example above) if you need it.

If you're working in a text box in Excel, you can select the text you want to change, right click it, choose Font, and check All Caps:

Font settings in Excel

Click OK and your text will be ALL CAPS. However, if you cut and paste the same text anywhere else, it will retain its original capitalization scheme. This could come in handy if you want to change the appearance of the text visually in an Excel text box but keep the original string intact for future use. If you ever want to make the change permanent (or choose a different capitalization scheme), it's easy to copy and paste the text into Word and adjust the capitalization there using the Change Case button on the Home tab:

Change case in Word

Then simply paste it back into Excel or wherever you need it.

Suzanne

Comments
  • none of those menus are in my excel, I use 2007

  • @bcg if you go to Insert Menu, you can find Text Box Button, if u press it your mouse pointer ll be changed so as to make u to draw a text box in which u can enter the text.

    after entering text in either case, u can right click over it and can choose font option, u can see the Font dialog box shown above.

    The last drop down menu here shown ll be available in word not in excel.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment