Solution Category: Worksheet editing
worksheet-editing
Name
Brief Description
Adds spacing characters in front of numeric ids so that their length is the same. ie 10 & 200 could be converted to 00010 & 00200. This allows for correct alpha-numeric sorting. Instead of data being sorted as [Team 1, Team 11, Team 2, Team 3], it will be sorted as [Team 001, Team 002, Team 003, Team 011]
Open dialog box to select desired folder
List all worksheets as a named range using cell ‘A1’.
Adds comments to cell(s) using text from the cell directly underneath the selected cell(s)
Replaces multiple instances of a defined character within a string with a single instance of a specified character ie “sdfdes——sdfhd—–kghgh—-hsdfh–” -> “sdfdes-sdfhd-kghgh-hsdfh-“