Split Text to Rows in Excel (3 Easy Ways)

[@trumpexcel]

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

[@IvanCortinas_ES]

Brilliant explanation. Grandmaster Sumit Bansal. Thank you!!

[@trumpexcel]

You are very kind my friend... Thank you for all the comments :)

[@michaellundsrensen2292]

I know Textsplit but you gave me new knowledge with your good examples. Thanks!

[@trumpexcel]

Glad the video gave you some ideas. If you do use TextSplit in any creative way, would love to know about it

[@Joseph-xt2qg]

You are an excellent teacher. Thanks!

[@trumpexcel]

Thank you so much for the kind words Joseph... Glad you are finding the videos useful :)

[@Satwant2463]

Thank you so much for this lesson. Highly useful.

[@trumpexcel]

Glad you found the video useful :)

[@nadermounir8228]

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]

Glad you found the video useful... will check out the FilterXML method :)

[@jonnathanjon1]

this is awesome. learned something new..

[@neccomputercenter458]

very useful for anybody. Thank you !

[@trumpexcel]

Glad you found the video useful :)

[@user-cq2ny2ki2z]

exactly what i was looking for! thanks.

[@trumpexcel]

Glad it was helpful 🙂

[@jagatkrishna1543]

Thanks ❤🙏 SIR

[@mohsinraza4453]

Accept love from Pakistan you are doing so so so well 💓

[@trumpexcel]

Thanks so much for the kind words Mohsin... I am glad you are finding the videos useful ❤

[@paulkingrex3222]

Thank you!

[@rajsuthar999]

👌 indeed useful 🎉

[@trumpexcel]

Thanks... Glad you found the video useful :)

[@da_ta]

Excellent thank you

[@trumpexcel]

Glad you found the video useful :)

[@Sonia-u8p2y]

Hi - very useful information. Thank you! How can i sort a large paragraph of text so I have 10 words in each row only?

[@TheMengdong]

Great, thank you!

[@girishpadshala9689]

Thank you, & vba code function.

[@marcusgenz4020]

I should worship for this, but I bow to man. 😂

[@kryss8302]

❤ Thank you!!

[@xeeshanahmad8757]

Hello Sir, Great To see you

[@trumpexcel]

Thanks for commenting... Good to be back on YT and making videos again :)

[@michaellundsrensen2292]

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]

You can check out this free VBA course - kzbin.info/aero/PLm8I8moAHiH2n5HC4ZXBgS-cBLjxWDreu

[@michaellundsrensen2292]

@@trumpexcel Thanks, Ill do

[@Bilegt0807]

Nice vido thank you so much! Is there a way to to combine line brake character and other elemenets? For example =TEXTSPLIT(A1,,{char(10),", ",": ", },)

[@triciaevans7303]

How to you split them into rows if there are rows already occupied with data underneath?

[@formylove5972]

sir mere excel me ye textsplit wala formula h hi nhi. or mujhe ye ache se smjhaaya tha av kya kru

[@sriprashanth123456]

Hi i am getting #Name error when i use this in vba I copied the code in description in to a separate module but when i use it in workbook, it shows “#Name?” Error, my intent is to split 3,4,10,5…. To rows Can you help me

[@subhabratade93]

mere liye spit ho nehi raja. sirf 1st word split ho raha hain.kaha par galti kar raha hun? Please help Sumit ji..

[@trumpexcel]

Can you share the formula here? Also, I am assuming you are using M365 and have TEXTSPLIT function in your version of Excel.