Text & Strings
Cut, search, split, join and reshape messy text until it looks like clean data.
The first lesson is free — no account needed.
About this course
Cut, search, split, join and reshape messy text until it looks like clean data. The course covers the VBA string functions Left, Mid and Right, InStr and InStrRev, Trim and case changes, Split and Join, Replace and the Like operator, Format, and building long strings efficiently.