See the full list of VBA functions here: https://excelmacroclass.blogspot.com/...
Welcome to Excel VBA Functions Series. In this video we see the array functions SPLIT, LBOUND, and UBOUND, used to split a string by a delimiter to create an array of elements with a lower and upper bound. We see several practical examples of the functions in detailed. Furthermore, we see a one line of code using these functions that get the occurrences of a character or string of characters within a main string.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)