How to Change Case in Excel

Text tools from Ultimate Suite for Excel is really good at trimming data imported from an external source. One of other handy features it has is the ability to change case in Excel 2016 - 2007.

Before you start

We care about your data. The add-in will back up your file if you select the corresponding option.

How to change case of cell values

To run the tool, click the Change Case icon that you'll find in the Text group on the Ablebits Data tab in Excel:
The Change Case tool on Excel's ribbon.
You will see the Change Case pane:
Lower, upper, proper, or sentence case.

  1. Select the range in Excel where you need to convert case.
  2. If you need to get the whole table selected, click the Expand selection icon.
  3. If you choose UPPER CASE, all the words within the selected cells will take upper case.
  4. Select lower case to turn all cell values to lowercase.
  5. Pick Proper Case to make the first letter of each word within a cell capital and all other letters lowercase.
    Note. If there are acronyms in your cells, only the first letter of the abbreviation will keep upper case.
  6. Make the first character in each sentence capital with the Sentence case option.
    Tip. You can run any of these options right away by clicking the down arrow below the add-in's icon and picking the necessary option from the drop-down menu:
    Change case directly from the Excel ribbon.
  7. As you can't undo changes made by add-ins in Excel, we recommend choosing to Back up the worksheet.

Click the Change case button to apply changes to the selected range.

Responses

Hi,

is it possible to exclude some words when using the "Proper case" option?

For instance, let's say I have the following sentence:
"He gave me the keys for his house"

And I would like to have it as follows:
"He Gave Me the Keys for His House"

That is, I'd like to use Proper Case for all words except for "the" and "for".

Is that possible?

Thanks!

Reply
Ekaterina Pechyonkina says:
January 5, 2020 at 12:10 pm

Hi Abel,

Thank you for contacting us. Sorry, it is not possible. The Proper case option is designed to make the first letter of each word within a cell capital.

Reply
LaChelle Rininger says:
October 19, 2020 at 3:47 pm

Every time I change the font to all upper on a sheet in a workbook, it creates a new sheet

Reply

Hello,

Thank you for your comment. It looks like you are referring to a backup copy of the worksheet the add-in creates to keep your original data. If you do not need it, please make sure there is no tick next to the corresponding option on the tool pane.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.