Solution Category: Cell formating
cell-formating
Name
Brief Description
Concatenate all cells in range with an optional separator
Changes format of whole number to percentage (ie 55 to 55.0%)
Applies common formatting settings to selected range
Adds or removes hyperlinks to cells in selected range using the contents of the cell as the address
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-“