You will soon be able to remove duplicates and trim white space in Google Sheets
What’s changing
Source: G Suite Updates Blog: Three new features to format and work with data in Sheets
We’re introducing three new features that will help you clean up and work with your data in Sheets. These features are:
* Remove duplicates
* Trim whitespace
* Compatible spreadsheet shortcuts
These are some great features that will be a lot more accessible than creating formulas that do the same thing.