VBA Tips: Formatting

Formatting

• Check if a string contains a value (and return its position)
• Convert to uppercase or lowercase (and check if a value is in uppercase or lowercase)
• Format characters in a cell
• Remove unnecessary spaces
• Replace values with others within a string (or remove them)
• Retrieve the color of a cell considering the applied conditional formatting
• Reverse a string