This helpful tool will quickly identify repeating records, whether it’s a cell or an entire row. Removing duplicates is not the only thing it can do. You can choose to include the original values or find only uniques, and then highlight, copy, move, or delete the found items.
We don’t always get our data the way we need it. If you happen to have a column with full addresses while you need to get street names, cities, and zip files under separate headers, this simple add-in will help you automate splitting text across multiple columns in Excel on the web.
Not only does this add-in let you find and replace table data right in your browser, but it offers search in any sheets, formulas, and more. Specify additional options, get a list of found items in each sheet, and you are a click away from replacing all or just some of them.