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 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 - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 33
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
Thanks ❤🙏 SIR
Thank you, & vba code function.
I know Textsplit but you gave me new knowledge with your good examples. Thanks!
@trumpexcel
5 ай бұрын
Glad the video gave you some ideas. If you do use TextSplit in any creative way, would love to know about it
Brilliant explanation. Grandmaster Sumit Bansal. Thank you!!
@trumpexcel
5 ай бұрын
You are very kind my friend... Thank you for all the comments :)
Thank you trump for this nice video especially the VBA part. U can also use filterXML along with the transpose function if u don't have the textsplit in your version of excel.
@trumpexcel
5 ай бұрын
Glad you found the video useful... will check out the FilterXML method :)
Accept love from Pakistan you are doing so so so well 💓
@trumpexcel
5 ай бұрын
Thanks so much for the kind words Mohsin... I am glad you are finding the videos useful ❤
very useful for anybody. Thank you !
@trumpexcel
5 ай бұрын
Glad you found the video useful :)
Thank you so much for this lesson. Highly useful.
@trumpexcel
5 ай бұрын
Glad you found the video useful :)
You are an excellent teacher. Thanks!
@trumpexcel
5 ай бұрын
Thank you so much for the kind words Joseph... Glad you are finding the videos useful :)
Excellent thank you
@trumpexcel
6 ай бұрын
Glad you found the video useful :)
❤ Thank you!!
👌 indeed useful 🎉
@trumpexcel
5 ай бұрын
Thanks... Glad you found the video useful :)
Hello Sir, Great To see you
@trumpexcel
5 ай бұрын
Thanks for commenting... Good to be back on YT and making videos again :)
sir mere excel me ye textsplit wala formula h hi nhi. or mujhe ye ache se smjhaaya tha av kya kru
How to you split them into rows if there are rows already occupied with data underneath?
How can I learn VBA from the beginning? I did code in Bacic and Pascal many years a go, and I make Macros and modify them slightly.
@trumpexcel
5 ай бұрын
You can check out this free VBA course - kzread.info/head/PLm8I8moAHiH2n5HC4ZXBgS-cBLjxWDreu
@michaellundsrensen2292
5 ай бұрын
@@trumpexcel Thanks, Ill do
mere liye spit ho nehi raja. sirf 1st word split ho raha hain.kaha par galti kar raha hun? Please help Sumit ji..
@trumpexcel
5 ай бұрын
Can you share the formula here? Also, I am assuming you are using M365 and have TEXTSPLIT function in your version of Excel.
THANK YOU SO MUCH!!!!
@trumpexcel
3 ай бұрын
Glad you found the video helpful 🙂