Remove Duplicates Larger data sets tend to have duplicate content. For example, you might have a list of multiple contacts in a company and only want to see the number of companies you have. In situations like this, removing the … Continue reading →

To remove unnecessary spaces, use =trim(text)

Quick Analysis is a new button that appears at the bottom right corner of selected data. Using this, you can do a lot of quick analysis tasks like sparklines, conditional formatting, charts, changing your data into tables or pivot tables.