In this video, I will show you three ways to split text into rows in Excel. While Text to Columns is an everyday need, many times, you may also want to split the text in a cell into separate rows.
This can be done easily thanks to some awesome formulas in Excel and VBA.
00:00 Intro
00:46 Split Text to Rows using TEXTSPLIT function
06:42 Split Text to Rows using Text to Columns and Transpose
09:10 VBA to Split Text to Rows in Excel
---------------------------------------------------------------------------------
Below is the VBA code used in this video
'Code developed by Sumit Bansal from https://trumpexcel.com
Function SplitCellToRows(CellValue As Range, Delimiter As String)
Dim SplitValues() As String
'Split the value by the specified delimiter into an array
SplitValues = Split(CellValue.Value, Delimiter)
'Go through each element of the array and remove any leading or trailing spaces
For i = LBound(SplitValues) To UBound(SplitValues)
SplitValues(i) = Trim(SplitValues(i))
Next i
'Return the array
SplitCellToRows = WorksheetFunction.Transpose(SplitValues)
End Function
---------------------------------------------------------------------------------------
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial