Solution Category: Worksheet editing
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-“