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
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1