![]() ![]() Technical Details and System Requirements See all open workbooks and sheets in one pane.Delete empty rows, columns, and sheets.Apply Average/Max/Min functions to the colored data.Select a certain color to count or sum cells.Count and sum cells based on their color.Split a column with text into several columns.Add text to the selected cells by position.Trim extra leading, trailing, and in-between spaces.Search and replace data in values, formulas, hyperlinks, and comments.Find partial duplicates, typos, and misspelled words.Save custom lists with values to get random data from them.Swap two ranges in your sheet or workbook.Convert the summary table to a flat list. ![]() Split multi-part names into several columns.Split a big table into separate lists by values in the selected column.Combine duplicate rows and paste unique data into one line. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |