![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |