![]() Convert numbers stored as text to numbers. ![]() Split a column with text to several columns.Add text to the selected cells by position.Trim extra leading, trailing, in-between spaces, and.Find and fix broken references to other workbooks.Search and export or select the found values. ![]() Search and replace data in values, formulas, hyperlinks, and comments.Find partial duplicates, typos and misspelled words.Fill empty cells with value above or below.Select certain number or percentage of data at random.Shuffle cells in rows, columns, or in the selected range.Generate strong passwords, codes, and testing data.Save custom lists with values to get random data from them.Convert rows to columns and vice versa.Flip the selected range vertically or horizontally.Swap two ranges in your sheet or workbook.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 to one line.Find and process duplicates and their 1st occurrences.Find and delete, select, color, copy or move duplicates in one Excel table.Compare two tables for duplicate and unique values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |