A User Defined Function (UDF) to split data into Rows and Columns in Excel is explained in this video.

Intro (0:00)
Splitter function which supports Dynamic Array Formulas (0:34)
Splitter2 for those who use Excel 2019, 2016 or lower versions of Excel (4:30)

Read about Splitter function
https://xlncad.com/excel-formula-to-split-data-into-rows-or-columns/

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

#Excel #FreeExcelCourse #SplitFunction