How to use SPLIT Function in Excel VBA - Two Examples

In this video, we will look at how to use the SPLIT function in excel VBA with two practical examples of its use. New to Excel VBA? Learn Excel VBA quickly - http://bit.ly/37XSKfZ The SPLIT function splits a string into substrings by a specified delimiter and returns it as an array. We can then test the parts of the array and perform whatever actions are necessary for our macro. The timings of the video are; 00:00 - Introduction to the SPLIT function 01:40 - Example 1 - Count number of words 06:17 - Example 2 - Extract from the second character 09:34 - Closing words Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/37XSKfZ