VBA Tips: Formatting

Formatting

• Check whether or not a string contains a defined value and return the position
• Convert to uppercase or lowercase (and check if a value is uppercase or lowercase)
• Format some of the characters inside a cell
• Remove unnecessary spaces
• Replace some of the values with others within a string
• Reverse a string