Expand your text string capabilities with two additional VBA functions
by Stephen Nebel
Microsoft Excel 2000/2002/2003/2007
We describe several VBA functions that you can use to work with strings in the article titled “Three ways to manipulate strings without retyping your data,” found in this issue. Another useful but somewhat obscure function for string manipulation in VBA is Split(). We’ll take a look at it here because it may provide you with some additional ideas for string manipulations.
1. A string.
2. An optional delimiter character, with the space being the default.
For an example of <[...]