Strings are fun to manipulate and VBA provides us with many tools such as Functions and Operators to slice and dice and shape text data any way we want.
In this long lesson, we will cover a lot of examples that we will help us:
- Insert Characters using Chr()
- Determine Length of a string using Len()
- Check whether a string is blank or not
- Join strings using & and + operators
- Extract parts of strings using Left(), Right(), Mid()
- Search within strings using InStr(), InStrRev()
- Split a string into a set of substrings using Split()
etc.
#vba #excel
Follow the rest of the series, in the below playlist:
https://www.youtube.com/playlist?list=PLgG3u13JJuEbguNAl0zbkq3mDCvy07v0Y
Code snippets can be found here:
https://skillsandautomation.com/master-class/working-with-strings-excel-vba-master-class/
00:00 Intro
00:43 String Characters
05:57 String Types
07:42 Empty String
10:33 Concatenation
11:27 String Manipulation
22:12 String Comparison
27:24 Formatting String
