Text tools from Ultimate Suite for Excel is a collection of utilities that are really good at trimming data imported from an external source. One of the handy features is the ability to change case in Excel.
We care about your data. The add-in will back up your worksheet if you select the corresponding option.
To run the tool, click the Change Case icon that you'll find in the Text group on the Ablebits Data tab in Excel:
You will see the Change Case pane:
Click the Change Case button to apply changes to the selected range.
Every time I change the font to all upper on a sheet in a workbook, it creates a new sheet
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.
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?
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.
How i should do it?
If you wish you can first use the Proper case option and then Advanced Find and Replace to replace the necessary word in bulk. I hope this workaround will be of help.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!