by Paul Kelly | Aug 18, 2015 | Strings and Text
The VBA InStr function is one of the most used functions in VBA. It is used to find a string within a string and indeed it does a very fine job. However, it is often used to help extract part of a string and for this task it performs badly. If you have found string...
by Paul Kelly | Jul 13, 2015 | Strings and Text
Quick Guide to String Functions String operationsFunction(s) Append two or more stringsFormat or "&" Build a string from an arrayJoin Compare - normalStrComp or "=" Compare - patternLike Convert to a stringCStr, Str Convert string to dateSimple: CDate Advanced:...