> ## Content Index
> Fetch the complete content index at: https://blog.tsd.digital/llms.txt
> Use this file to discover other available public pages before exploring further.

# Excel change case -sentance, proper, lower and upper
- URL: https://blog.tsd.digital/excel-change-case-sentance-proper-lower-and-upper/
- Published: 2006-12-05T14:38:04.000Z
- Updated: 2006-12-05T14:38:04.000Z
- Author: Tim Gaunt
- Tags: Office, #Import 2025-04-01 05:34

Have you ever been sorting through a client’s product data and needed to change the case of the text? This is a great little add-in for Excel that can help.[Download the zip file](content/binary/caseconvert.zip) and run the xla file, you’ll then have a new option “Convert Text” under your “Tools” menu:

![Excel change case "Convert Text" Tool Menu](https://storage.ghost.io/c/64/5b/645b11c2-b436-444c-a523-58dca4ca7bd8/content/images/img/Excel-Change-Case-Menu.png)

To use it, select the text you want to change and then choose “Convert Text”, you can then choose from:

- lower case
- UPPER CASE
- Proper Case
- Sentence case

It also has a number of other useful options like removing white space, adding characters etc.

![Excel Change Case Dialog Window](https://storage.ghost.io/c/64/5b/645b11c2-b436-444c-a523-58dca4ca7bd8/content/images/img/Excel-Change-Case-Dialog.png)

[Download the Excel Change Case Add-in here](content/binary/caseconvert.zip)