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 OctThis Excel chart *WILL* surprise you 😮BRILLIANT Excel Trick to Get One Pivot Table from Many Sheets 🤯50 things you didn't know Excel can DO 💡TOP 10 XL Functions #excelDON'T tell my boss, but ChatGPT made this Excel dashboard 🤫Example Data Analyst Interview Question - Can you solve this? 🤔I don't use PIVOT tables anymore... I use this other thing instead!Excel Magic Revealed: Unstacking Data Like a Pro! ✨How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)What is Microsoft Fabric & what can we DO with it?Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...How to make a Map Chart in Excel - Quick & Simple TutorialONLY Excel pros use this INDEX MATCH trick 💡How to make an Interactive & Beautiful Excel Dashboard in 5 StepsI got braces in my 40s!6 *proven* strategies I used to make $100,000+ with my Excel SkillsHoney, I shrunk the lengthy Excel formula (by 80%😮)FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work 🚀Make a beautiful and interactive To-Do List with Excel (Easy Tutorial 👌)