In this lesson, we explore String Manipulation, one of the most essential skills for VBA automation. Whether you are parsing file paths, cleaning user input, or generating reports, these functions allow you to slice, dice, and transform text with precision.
Key Takeaways:
- Space Cleaning: Use Trim to remove all leading and trailing spaces.
- Casing Control: Use UCase for UPPERCASE and LCase for lowercase.
- Extraction (Start/End): Left grabs characters from the start; Right from the end.
- Middle Extraction: Mid pulls a substring starting from a specific position.
- Finding Text: InStr finds a string’s position; returns 0 if not found.
- Reverse Search: InStrRev searches from the end (perfect for file extensions).
- Search and Replace: Replace swaps specific characters or words within a string.
- Arrays to Strings: Split breaks text into an array; Join puts it back.
