Cart 0

How to convert data to Proper Case in Excel

Posted by Roger Hyttinen on

Last week, a collegue sent me a list of data that was in all uppercase. He asked me if I knew of any way to convert it into proper case, in which the first letter of each word capitalized. The answer: Use the “Proper” Function.

Here’s how to convert uppercase (or lowercase) list to sentence case.

  1. Let’s say that the list that we want to convert was in A3:A130. In cell B1 type: =Proper(A3)
  2. Drag-copy the formula down to B130.
  3. With the Range B3:B130 still selected, press the Ctrl-C keystroke combination to copy the data to the clipboard.
  4. Press Ctl-Alt-C to display the Paste Special dialog box.
  5. Click the Values radio button in the Paste Special dialog box. You can now delete column A.
Likewise, the Upper function converts all of the data to uppercase and the Lower function converts all data to lowercase.

    Share this post

    ← Older Post Newer Post →

    Leave a comment

    Please note, comments must be approved before they are published.