How to use TEXTSPLIT() in Excel
Have you tried the new TEXTSPLIT function in Excel? It is crazy I tell you.
We can use it to split text to multiple value. For example,
👉 Got a full name in a cell and need to split first name & last name? TEXTSPLIT() it
👉 Have some email addresses in a cell and need to separate them? TEXTSPLIT to the rescue
👉 Working late because you don't know how to use Excel and your partner hates you for that? You can either split or try some of that juicy TEXTSPLIT... 🤣
Let me show you how to use TEXTSPLIT with one simple and two advanced examples.
~
Learn more about some of the most useful & time-saving features of Excel.
My top 10 - I Saw my boss do this in Excel (Almost 2 mn views) - https://youtu.be/HgfC3etOgsU
How to use IF formula in Excel - https://youtu.be/15NtFld9mVM
10 Advanced tips on IF formula - https://youtu.be/-yFpzIRifK4
How to use FILTER in Excel - https://youtu.be/JuTdj2j-9Kg
How to use XLOOKUP in Excel - https://youtu.be/DDlZXXEI1bU
More videos on Excel Formulas - https://www.youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM
~
#excel #textsplit
Видео How to use TEXTSPLIT() in Excel канала Chandoo
We can use it to split text to multiple value. For example,
👉 Got a full name in a cell and need to split first name & last name? TEXTSPLIT() it
👉 Have some email addresses in a cell and need to separate them? TEXTSPLIT to the rescue
👉 Working late because you don't know how to use Excel and your partner hates you for that? You can either split or try some of that juicy TEXTSPLIT... 🤣
Let me show you how to use TEXTSPLIT with one simple and two advanced examples.
~
Learn more about some of the most useful & time-saving features of Excel.
My top 10 - I Saw my boss do this in Excel (Almost 2 mn views) - https://youtu.be/HgfC3etOgsU
How to use IF formula in Excel - https://youtu.be/15NtFld9mVM
10 Advanced tips on IF formula - https://youtu.be/-yFpzIRifK4
How to use FILTER in Excel - https://youtu.be/JuTdj2j-9Kg
How to use XLOOKUP in Excel - https://youtu.be/DDlZXXEI1bU
More videos on Excel Formulas - https://www.youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM
~
#excel #textsplit
Видео How to use TEXTSPLIT() in Excel канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Present Data for Executive Audience - FREE Masterclass 1PM ET, 27 Oct](https://i.ytimg.com/vi/Tu6ooTQp2gc/default.jpg)
![This Excel chart *WILL* surprise you 😮](https://i.ytimg.com/vi/WYfk5TnzO-8/default.jpg)
![BRILLIANT Excel Trick to Get One Pivot Table from Many Sheets 🤯](https://i.ytimg.com/vi/gi-DSWEUC-A/default.jpg)
![50 things you didn't know Excel can DO 💡](https://i.ytimg.com/vi/Tzuk3NH_u3I/default.jpg)
![TOP 10 XL Functions #excel](https://i.ytimg.com/vi/vQIgNQ6UfFM/default.jpg)
![DON'T tell my boss, but ChatGPT made this Excel dashboard 🤫](https://i.ytimg.com/vi/mp18miYmmJY/default.jpg)
![Example Data Analyst Interview Question - Can you solve this? 🤔](https://i.ytimg.com/vi/cMEvyhvd5Es/default.jpg)
![I don't use PIVOT tables anymore... I use this other thing instead!](https://i.ytimg.com/vi/SPFQX82X03Q/default.jpg)
![Excel Magic Revealed: Unstacking Data Like a Pro! ✨](https://i.ytimg.com/vi/fOokEIZlh8I/default.jpg)
![How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)](https://i.ytimg.com/vi/H6k28jhclwI/default.jpg)
![What is Microsoft Fabric & what can we DO with it?](https://i.ytimg.com/vi/--cK4A2djoA/default.jpg)
![Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...](https://i.ytimg.com/vi/fOyvqXxADvE/default.jpg)
![How to make a Map Chart in Excel - Quick & Simple Tutorial](https://i.ytimg.com/vi/qNNn5uiZxOE/default.jpg)
![ONLY Excel pros use this INDEX MATCH trick 💡](https://i.ytimg.com/vi/v4RnVh2iGgU/default.jpg)
![How to make an Interactive & Beautiful Excel Dashboard in 5 Steps](https://i.ytimg.com/vi/35VnP0Rz71I/default.jpg)
![I got braces in my 40s!](https://i.ytimg.com/vi/3uNjbewTGGw/default.jpg)
![6 *proven* strategies I used to make $100,000+ with my Excel Skills](https://i.ytimg.com/vi/USU2AzGWu_Q/default.jpg)
![Honey, I shrunk the lengthy Excel formula (by 80%😮)](https://i.ytimg.com/vi/HCEIzeIdiD0/default.jpg)
![FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work 🚀](https://i.ytimg.com/vi/yJum0g4qM2c/default.jpg)
![Make a beautiful and interactive To-Do List with Excel (Easy Tutorial 👌)](https://i.ytimg.com/vi/mA93MQgKRTc/default.jpg)