by Paul Kelly | | Strings and Text, VBA Language
Welcome to this article on the VBA Left, Right and Mid string functions. In this post, I will show you when to use these functions and equally importantly when to avoid using them. If you use them for the wrong type of tasks(i.e. extracting from variable strings), you...
by Paul Kelly | May 7, 2019 | Strings and Text
Introduction The VBA Split Function is used is to split a string of text into an array. The text is split based on a given delimiter – e.g. a comma, space, colon etc. For example, imagine we have the following string: “Apple:Orange:Pear:Plum” You can...
by Paul Kelly | | Strings and Text, Vault Video
Webinar Number: W0006 The following video provides an in-depth guide to using string functions in Excel VBA. It is based on this VBA Strings article. See below the video for the code on the Printf statement. Related Links The Ultimate VBA Tutorial Part One The...
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:...
