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