In this video, I will show you a big limitation of the TEXTSPLIT function in Excel. While it works great when you just select one cell and use it to split the text, in case you select multiple cells in one go, it wont split the text as expected.
I have covered two methods to get around this TEXTSPLIT limitation so that it works as expected.
➡️ Download FIle: https://www.dropbox.com/scl/fi/c8b20nqxpnbovoj4i9i3z/TextSplit-Workaround.xlsx?rlkey=s0coajz22sp9k3dq6642dfkp1&dl=1
00:00 Intro
00:25 Issue with TEXTSPLIT function
01:37 Using TEXTJOIN Function
04:20 Using REDUCE 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 #SumitBansal