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
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.
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
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
Brilliant explanation. Grandmaster Sumit Bansal. Thank you!!
You are very kind my friend... Thank you for all the comments :)
I know Textsplit but you gave me new knowledge with your good examples. Thanks!
Glad the video gave you some ideas. If you do use TextSplit in any creative way, would love to know about it
Thank you so much for this lesson. Highly useful.
Glad you found the video useful :)
You are an excellent teacher. Thanks!
Thank you so much for the kind words Joseph... Glad you are finding the videos useful :)
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.
Glad you found the video useful... will check out the FilterXML method :)
very useful for anybody. Thank you !
Glad you found the video useful :)
Accept love from Pakistan you are doing so so so well 💓
Thanks so much for the kind words Mohsin... I am glad you are finding the videos useful ❤
Thanks ❤🙏 SIR
Thank you, & vba code function.
Excellent thank you
Glad you found the video useful :)
Hello Sir, Great To see you
Thanks for commenting... Good to be back on YT and making videos again :)
👌 indeed useful 🎉
Thanks... Glad you found the video useful :)
I should worship for this, but I bow to man. 😂
❤ Thank you!!
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.
You can check out this free VBA course - ua-cam.com/play/PLm8I8moAHiH2n5HC4ZXBgS-cBLjxWDreu.html
@@trumpexcel Thanks, Ill do
sir mere excel me ye textsplit wala formula h hi nhi. or mujhe ye ache se smjhaaya tha av kya kru
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
How to you split them into rows if there are rows already occupied with data underneath?
mere liye spit ho nehi raja. sirf 1st word split ho raha hain.kaha par galti kar raha hun? Please help Sumit ji..
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!!!!
Glad you found the video helpful 🙂