Generate random numbers, dates, booleans, custom lists, or strings Shuffle values in rows, columns, or the entire range Split 'Date time' cells into cells with the date and time units Split one table into multiple sheets by columns. Separate first and last name in Google Sheets, extract titles and other name parts into individual columns Separate values by any character or strings Fill empty cells with values from adjacent cells and autofill formulas Handle several Google sheets in one go with ease Find and replace in values, formulas, links, errors, and notes Sort whole rows or only the selected range by the fill/font colors V-lookup multiple matches based on multiple criteria Replace accented characters with regular, smart quotes with straight ones, turn codes to symbols and back From the beginning / the end / or the exact positionģ. Remove HTML entities and tags, non-printing characters, and delimitersĢ. Remove characters by position, or when they follow or precede certain textĦ. Remove line breaks, commas, and any characters or strings in the rangeģ. Get rid of any characters or strings in the rangeĢ. At the beginning or at the end of the selected cellsġ. Capitalize each word or cell, change case to uppercase or lowercase, toggle and polish textġ. Consolidate data from several sheets into one summary report Combine data from multiple sheets into one based on column headers Merge two Google sheets by key columns: vlookup data from another table considering text case and ignoring blanks Merge cells in rows, columns, or the entire range and keep all records Combine duplicate rows and merge unique data referring to the same record Highlight duplicates or uniques, copy or move them to another location Compare two columns or sheets to find duplicates Find and remove duplicates in any combination of columns in your sheet Handle multiple sheets in one go: (un)hide, (un)protect, copy, move, change color, reorder, delete. Capitalize first or all letters, apply sentence and lowercase, toggle text Sum and Count colored cells (other functions included) Search in values, formulas, links, errors, and notes ➊ Smart toolbar offers some one-click actions. Text toolkit utilities are also included and let you change case, add and remove strings and characters, trim whitespaces, and split text to columns.Īll the tools are divided into 10 different groups based on their main purpose:
It cuts the clicks on repeated tasks and enhances your Google Sheets with features that organize and unify your data.Īmong its add-ons you'll find those that remove duplicates, compare and vlookup sheets, import ranges from multiple sheets, merge cells, find and replace data, sum and count colored cells, generate numbers and other records. If bringing your spreadsheets to order in the shortest time possible is your goal, Power Tools is a must-have.
0 kommentar(er)
