Many times we need to change the case like upper/lower/proper/capitalize each word/toggle in google sheet.
This can be done by formulas. But wait !! what if you want to change the case with multiple cells with active selection.
This will require knowledge of formulas & it has to be write formulas multiple times for each cells.
This tool will help you to to change the case like upper/lower/proper/capitalize each word/toggle in active tab selection.
CLICK HERE to Install the addon.
How to Open Functionality:
- First of all open the Google sheet then go to Extension > Sutra Tools > Utilities > Change Case like below screenshot:
Use of Functionality:
- This Functionality is use only current tab Active selection range list.
- After click on Change Case it show 5 more options:
- Upper: It will use to convert string to uppercase in active tab range list
- Lower: It will use to convert string to lowercase in active tab range list
- Proper: It will use to convert string to propercase(first letter of string will be capital) in active tab range list.
- Capitalize Each Word: It will use to capitalize each word to uppercase in string in active tab range list
- Toggle: It will use to convert string to toggle(upper to lower and lower to upper) in active tab range list