If you think about almost everything you do in Excel, it involves some form of manipulating numbers or text. The same is true with VBA.
In this post, I want to show you some simple manipulations of text in VBA .
When folks are asked to type text, there is usually no way to know how long or short the text is going to be. If we really want to, we can put rules and restrictions to control the text. But, there is only one variable type.