Скачать с ютуб Split Text to Rows in Excel (3 Easy Ways) в хорошем качестве

Split Text to Rows in Excel (3 Easy Ways)

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-c... ✅ 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/trumpexc... #Excel #ExcelTips #ExcelTutorial