122. Genialna Funkcja PODZIEL.TEKST - Nowa Dynamiczna Tablicowa Funkcja Excela 365

Who am I? Wojciech Wiśniewski, I've been a financial analyst for over 25 years. I've worked in various companies: manufacturing, service, and consulting, where I performed financial analysis, company valuations, and controlling. Financial analysis and Excel are not just my daily work, but also my passion. I've noticed how Excel can free up time so you can devote it to other important matters, such as learning Excel. Today, Excel is an advanced work tool essential for those in finance, but not just finance. It's widely used in HR and logistics, as well as in office work. Every day, I strive to learn new Excel features, including pivot tables, Power Query, Power Pivot, and VBA, which create extraordinary Excel capabilities, and then I share my knowledge with you. I invite you to the world of New Excel 365 Table Functions. I'll show you a series of dozens of new Excel functions that will significantly simplify and speed up your work. And when you combine these functions with other functions, you multiply their capabilities. Remember, these functions only work in Excel 365. We begin this series with the brilliant SPLITTEXT function. The SPLITTEXT function is often used to split text based on a specific separator. It's a very useful tool when you want to extract specific pieces of information from a long string of characters. The SPLITTEXT function can be especially useful when you're working with data that's been combined into a single cell, but you need to split it into smaller pieces for easier management. Remember also that a separator doesn't have to be just a single character. It can be any sequence of characters, such as a space, a comma, a dash, a period, etc. In this video, I'll show you the following: 1. Arguments of the SPLITTEXT function 2. A simple example of splitting text with a first and last name into two columns 3. How to eliminate unwanted elements from split text? 4. Multiple text separators in a column. How can I handle this and split text into columns despite having multiple different splitters? 5. How can I split text in a single row into columns and rows based on different splitters? Excel solution file for the example I present in the video: https://bit.ly/3jVyRhk Table of Contents: 00:00 - Introduction 02:03 - Arguments of the DIVIDERTEXT function 03:05 - A simple example of splitting text with a first and last name into two columns 04:00 - How can I eliminate unwanted elements from split text? 07:30 - Multiple text separators in a column. How can I handle this and split text into columns despite having multiple different splitters? 10:39 - How can I split text in a single row into columns and rows based on different splitters? 13:09 - Conclusion and other videos on my YouTube channel But I also have great news for you! Click on the right side of the banner and download the eBook on the 10 Most Important Financial Functions in Excel. I'm currently creating an online course based on this eBook, which you can purchase. A whopping 68 pages of examples, no fluff, and only when necessary. The eBook also includes Excel files! To receive the eBook, sign up for the Newsletter, where I'll regularly present you with the most interesting Excel solutions from other developers. I cordially invite you to sign up for the Newsletter and download the free eBook. You get two benefits with just one click! If you'd like to download the eBook "10 Most Important Financial Functions in Excel," you can click the link below: https://subscribepage.io/ebook10funkc... Please contact me - I can help you with Excel or conduct individual or company training: Wojciech Wiśniewski phone: 600 839 522 email: [email protected]