How to Change Case (Upper, Lower, Sentence) in Excel

Text Toolkit 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.

1. Goto insert and click on Get Add ins
2. Search for Change Case Add in and add into excel
3. Check My Add ins whether it is added or not if yes,
4. Select the range in Excel where you need to convert case.
5. If you need to get the whole table selected, click the Expand selection icon.
6. If you choose UPPER CASE, all the words within the selected cells will take upper case.
7. Select lower case to turn all cell values to lowercase.
8. 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.
9. Make the first character in each sentence capital with the Sentence case option

Watch Complete Steps on YouTube