You can read more about it here( or get VBA code): https://www.excelhow.net/how-to-split...
This Excel video tutorial on splitting multiple lines from a cell into rows. In this tutorial, we'll explore two methods: using a formula with TRIM, MID, and SUBSTITUTE functions, and utilizing VBA code.
Time Stamps
00:00:15 Method 1: Split Multiple Lines from a Cell into Rows using Formula
00:02:06 Method 2: Split Multiple Lines from a Cell into Rows using VBA Code
#########
Learn Microsoft Excel Online Free: https://excelhow.net/
#########