In Excel, it is not possible to underline (or change formatting) of a sub-string in a cell with search-and-replace, conditioanl formatting or formulae. A workaround is to copy text to a word document ...

Don’t struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA. If you want to work with VBA, eventually, you’ll struggle with embedded strings. It ...