Power Tools provides you with various utilities to speed up most of your daily tasks. Using this tool, you can fulfil a few main tasks in a spreadsheet: change case, replace special characters, and polish text.
The Text tool cannot process dates. Cells formatted as dates will be ignored to avoid data corruption.
Open the Change case group to modify the text capitalization in the selected cells:
Convert all values of interest to lowercase by picking this radio button.
Once the option is chosen, click Run and the case will be changed.
Use this accordion to get rid of all special characters without breaking your data. It will help you make all characters in the range of interest uniform:
E.g., you import book titles from the web, and some of them contain codes like "War & Piece". Use this tool to change those codes into their corresponding symbols — "War & Piece".
After you choose what to replace, click Run and see the changes in the range of your choice.
This group contains the most commonly used options to bring all text in your spreadsheet back to its normal readable form:
Check some or all boxes depending on what you need to normalize and press Run. The text in the selected range will be polished in no time.
Hi,
Which option I can use to find duplicate numbers?
And how to remove them automatically?
Hi Hatem,
Thank you for contacting us.
If we understand your task correctly, our Remove Duplicates may be helpful. The add-ons allow you to remove duplicate rows, cells and compare 2 tables for duplicates. Just run Power Tools, go to the Dedupe and Compare section and choose the necessary add-on.
Currently, it's impossible to run our add-ons automatically. You need to run it each time you want to remove duplicates. However, our Remove Duplicate Rows contains scenarios that let you save the options you select most often and run them in a click. Depending on your task, you may find this feature helpful.
Feel free to contact us again if you have any other questions or need further assistance.
Is it possible to make it so that each time I write, each word will be capitalised by default? (as opposed to me having to select that cell and manually capitalise it with Power Tools).
Also, is it possible to make the text always centred by default? Sometimes when new cells are inserted/old cells are deleted/merged/unmerged, the text is aligned to the right.
Thank you for your interest in our product, Ehud.
I'm afraid it's technically impossible to keep our add-on running on the background applying the cases right away. You need to run it each time you need to capitalize cells. A quicker way to start the operation is from the Recent tools tab at the bottom of Power Tools.
As for centring, you need to select all new cells and apply the necessary alignment using the Google Sheets standard utility. Alternatively, you can use their Paint format tool to copy the formatting from one cell to other cells.
The text functions don't seem to be working for me. I have tried to use the change case (Capitalize each word) to clean up some survey data that I had, but after highlighting the cells and selecting "Run" nothing happened.
I am in a trial period and used a few of the deduplication functions successfully, but I don't know if I can decide on the value if some of the featured tools aren't working as expected.
Thank you for contacting us, Jimmy.
Please try to apply lower case to your data first. This was made intentionally in order not to corrupt any acronyms you may have.
You can also find the explanation in this section of the instructions above.
Hi! Is there a way to customize the Replace symbols option? I wish to change ä to ä. Thanks!
Hi Marja,
To look for particular symbols and text strings and replace them all with others, please use another tool of ours designed for this purpose: Advanced Find and Replace.
With this add-on, you can find and replace all instances of the symbol on all sheets at once.
Is there a way to reverse name placement? For example,
Sargent,Kristin
I need it to look like Kristin Sargent
Thank you for your question, Sheli.
A couple of our add-ons will help you (both of them can be found in Power Tools):
Please let us know if you have any other questions.
Is there a way to calculate the number of characters in a cell and add it to a number in a cell? For example, the value of 3 would be 3, but the value of 3UW would be 5. The value of URW would be 3, etc
Hello Ben,
Thank you for contacting us. As much as we'd like to help, we do not have a tool that could help you with your task at the moment. Sorry.
