Wise Owl Answers - How do I split text into multiple rows in Excel VBA?

Check out our other answers here    • Wise Owl Answers  

Get files here https://www.wiseowl.co.uk/vba-macros/...

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video shows you how to use the Split function in VBA to divide a string into multiple substrings based on a delimiter character. You'll also see how to capture the result of the Split function in an array and write the contents of the array into cells in a worksheet after inserting new rows to make space for the new values.

Chapters
00:00 The Question
00:42 The Basic List
01:36 Splitting a String
03:51 Counting Through an Array
05:23 Writing Array Values into Cells
06:55 Resetting the Worksheet
08:24 Inserting Rows into the Worksheet
09:31 Resetting the Worksheet
10:54 The Find and FindNext Methods
16:22 Avoiding Endless Loops with FindNext
18:00 Finishing Touches

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more