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