Concatenate all cells in range with an optional separator

Dale Anderson

Changes format of whole number to percentage (ie 55 to 55.0%)

Dale Anderson

Sets all selected cells to have no indentation

Dale Anderson

Adds or removes hyperlinks to cells in selected range using the contents of the cell as the address

Dale Anderson

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-“

Dale Anderson