New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)
Вставка
- Опубліковано 31 лип 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Dive into the world of Excel's latest addition, the TEXTSPLIT function, which revolutionizes the way you handle text splitting, especially when dealing with multiple spaces, commas, or various delimiters.
This video is a comprehensive guide to understanding and utilizing TEXTSPLIT, showcasing its ability to simplify complex tasks that would otherwise require lengthy formulas.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/textsplit-file
Key TEXTSPLIT Features and Examples:
▪️ TEXTSPLIT Basics: Learn the fundamental use of TEXTSPLIT to split skills listed in a cell into multiple cells using simple delimiters like commas or spaces.
▪️ Handling Multiple Delimiters: Discover how to handle various delimiters within the same dataset, including commas, semicolons, and colons.
▪️ Skipping Blanks and Ignoring Unwanted Text: Understand how TEXTSPLIT can ignore empty cells or specific text (like titles) to refine the results.
▪️ Splitting Text in Rows & Columns: Explore TEXTSPLIT's ability to organize data both vertically and horizontally, transforming a single cell's data into a structured format.
▪️ Split, Sort & Stitch Back: A fascinating use case where TEXTSPLIT is combined with other functions like TRIM, SORT, and TEXTJOIN to split, sort alphabetically, and recombine data into a single cell.
Availability of TEXTSPLIT: Available in Microsoft 365 and Excel for the web. More info in the Microsoft Excel announcement: techcommunity.microsoft.com/t...
00:00 How to Split Text Into Different Columns
00:38 TEXTSPLIT Basics
02:45 Ignore Empty Cells/Skipping Blanks
03:56 Split Text in Rows & Columns
04:41 Split, Sort & Stitch Back
06:54 Wrap Up
🎬 LINKS to related videos:
- We FINALLY Get the Excel Functions We Want: • Breaking News! We FINA...
- NEW Excel Formula Editor: • How to Use the NEW Exc...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Grab the file I used in the video from here 👉 pages.xelplus.com/textsplit-file
Yes We Liked
Very useful function, thanks!
Dear Leila mam, when you typing the formula in B2 cell, then in cell address box showing NPER. Why?
Well done. I'm thinkin of purchasing Office 365 to take a closer look of that trim formula. ↔️🔱
@@hansklein3649 The best investment I made since two years now.
Wow! How does anyone learn this stuff on their own? Even seemingly simple functions have these hidden features. I always learn so much with your channel. Cheers!
I think maybe someone who goes through each and every update that Microsoft documents on their site. Someone like leila lol
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Thanks for your simple, no-nonsense way of explaining. It's always a pleasure to watch your videos.
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
That is a really powerful function and your example and explanation on how to use it is just brilliant. Very helpful.
Amazing function. A great alternative for "text to column" functionality of Excel.
Your videos are very informative and always on point. Thank you!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Leila you are amazing! I have been watching your tutorials & I just love you!
Leila Gharani
I am very grateful to you , you helped me a lot in improving my creativity and productivity at work.
Thanks from Egypt.
Thank you for showing this. I've been waiting for this since the 90's! Seriously, it's been that long!
This is great tip about excel. The video and explanation was super helpful. Thank you!
OMG! I swear I love you. This is awesome. Happy New Year. So helpful. Thank you. ❤️🙌🏾
Happy new year!!
Hi Leila. So glad to see this! Can finally retire FILTERXML/SUBSTITUTE combination to split text. And, nice to see the additional functionality built in with the optional arguments. Count me as excited about this one. Can already think of many uses. Thanks for demonstrating. Thumbs up!!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Leila, you're amazing! You showed me how to do what I was doing in a faster, cleaner way. Thanks!
SUPERB - as EVER... THANKS, Leila - Keep up the GREAT work! 👍👍👍
Thanks for your effort. Your videos helps to learn things with explanation.
I have never seen such videos, these are brief very well explained in short time and most importantly free of cost😊
Very nice. As an Excel instructor, I'm blown away by the new formauls AND how well you present topics. Thank you
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
As an Excel enthusiast, I am so happy and excited with the fact that this fantastic software is continuously evolving and paving way to unlimited possibilities when it comes to data manipulation and analysis.
MVPs like you Leila, is helping us a lot to grasp the new concepts with ease. Good job and keep it up.
Very excited, thanks a lot for wonderful functions 🌹🌹
Textsplit is a great function - so many possibilities when nested with other functions as you have clearly demonstrated.
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Awesomes new excel function, even better the way you presented it. You rock!! Thanks
An excellent explanation. You make the math in the equation so easy to grasp.
I’m such a big fan.. I love your channel!!!
My mind is blown up to pieces by this lovely function. Ms. Leila all excel users should admire you for this free informstion. 🤩🤩🤩🤩🤩🤩🤩😍😍😍😍😍😍😍😍😍
You're very welcome!
Wow, I’m speechless… the last example goes beyond my imagination!! Thank you so much Leila for sharing over and over your Excel knowledge through well explained videos. You are an inspiration!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Excellent, you have cracked it already the new function, Superb, keepit up
Great! Please continue sharing your knowledge.
Shout out to you ma'am!!!!
❤I love this. Wish I know it sooner. I always have to use text to column when I have to split name to separate columns especially those with the Dr. in front of their name. Thank you Leila for showing us this.
The Text Split Function is amazing in application with ease of use.
Thanks for sharing this knowledge Leila, I'm keen to see how this will save time/effort (if at all) when you need to split "flattened" versions of tables (e.g. from a PDF document) where columns either side of a "Description" column have a fixed size (somethings they don't!)
Thank you for the great examples Leila!
Leila Sensei is wonderful. Thank you so much. It was amazing 🤩. The examples are extraordinary helpful. Thank you so Leila Jane.
Glad you liked it!
These videos are never boring... thank you
Very good examples of how we can put TEXTSPLIT to use. Especially the SORT option. Thank you Leila!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
I have amazing moments, watching your tutorials.
The new excel functions including the “textsplit” are just awesome! Thanks for sharing, Laila!👍🏻
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Lady, thank you so much. Easy explanation.
Yes I wish I had this decades ago! You are amazing.
Tolle Tipps, klar und einfach präsentiert - vielen Dank dafür und Grüße in meine Heimat
Thats an awesome new function! Thanks for making a video about it!!!
Simply amazing, superbly superb way of describing the much needed information - Loved it.
Glad you liked it!
I enjoy all the smart videos you post Leila "Guru" Gharani!
This is a great channel, thanks for all this information!!!
You do a great job explaining these!
One of the best channels to upscale your skills 😊😊😊👍
Esta chica es LA MERA RIATA!!!!! I mean when it comes to MS apps, look no further! Mis respetos!!!! and a big GRACIAS!
Excel does have awesome text functions. This video just shows a few of them! There are many others!
Thank you "Maestra Leila", you are always teaching us great Excel things. Saludos desde México 🇲🇽
De casualidad sabes cómo viene esa función en español?
BTW I've subscribed to your channel the easy intro to TEXTSPLIT and a couple of others I watched has sure made me a FAN!!😏
Glad to have you aboard!
ever since 1992 I have been waiting for this function! Thank you so much for demonstrating this... It used to be so tedious in the past.
It really was about time.
@@LeilaGharani not wrong... love your videos and always a great place for reference.
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Love the way you present these functions in a simple way. Thanks again for sharing. 😊
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Thank you so much for this new function! Can't wait to have this on my 365!
I love this formula.. So simple and powerful
Recently learned LET, FILTER, and XLOOKUP from your videos. Very very useful at work!!! Thanks for this one too!!!
Thanks for explaining in simple way.
Always the best instructor i ever see in UA-cam, i m giving excel training to people and your work makes me amazing for that people..you are just hero
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
I’m so
Glade I stumbled on your channel 💓
Thanks so much. Fantastic supermodel instructor. ❤
Amazing Liela making an amazing video that explains amazing and new function😃😃😃
Awesome. Thanks from Kalimpong, India
Thank you for the detailed video regarding TEXTSPLIT :)
This video was very helpful with the splitting of a full name in one cell, then dragged the cells down to replicate the rest of the list. Saved me another good half hour of work. Thank you so much!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Slow clap Leila. I have learned things I never knew existed in Excel with your channel. Thank you. Here's another thumbs up and saved video to my Excel playlist.
Thanks for the thumbs up, Gabriel!
Wasn't what I needed, but I saw another of your videos for TEXTBEFORE and TEXTAFTER that did the trick! Thanks! Saved me a ton of headache trying to figure out Visual Basic for my needs. I wish I had the need to use Office products enough to take your VB course, but I'd never use it enough to remember what I learned. 😕
Leila - you've got the best Excel videos out there! Thank you so much.....any updates as to when Microsoft will be distributing these new functions to Office 365 users? We need these fast!!
This is really cool! Thank you so much for the sharing!
This makes my job much easier. Thanks for the update.
Omg that’s just mind blowing…. What a function !!!! 🤩
Thank you Leila! I'll try it tomorrow again on my work! :)
Thank you very much. This vid is very helpful
Extremely clear video!!
Pretty cool function! Thanks
Fantastic! Thank you Leila!
Its just Amazing. Thank you for this
Thank you! I've learned something great!
Thank you very much Leila! That’s really helpful! 🥰
Got here from your udemy course on Macro and VBA. Thank you for transferring your golden knowledge!!!
Thank you! Very useful!! Love it!
Amazing demo. Looking forward to putting this function to work
This has just single handedly changed the way I work. Amazing! So much time saved again
Great to hear! 🙌
Genius.. 😊
Your ideas on some data analysis, cleansing etc is amazing!
I salute you Leila 🙏!
When is this function coming to XL?
I have Office 365 but nothing yet! 😳
This was really helpful. Thank you so much!!
Very much excited, but need to wait for these functions to become generally available! Until then, you are going to make us expert in their usage through your videos Leila, and thanks a lot for that! You are amazing! 😊👍
Always good to be prepared 😁
@@LeilaGharani how can I contact you
@@paulraj9129 you just did 😂😂
Wonderfully explained and nice to finally have these new features. We have been waiting for this for about 20 to 30 years. Thanks for the video!
Glad you liked it Andreas!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
This is a great function and thanks for your insights and some sample utilization in a fomula, Leila. As awesome as always. Thanks for sharing.
Thank you, Leila! You Are The Best
Thank you for sharing. This is a great function
Ahhhh new tool unlocked! This is what I'm missing in my master list. Thanks.
Wow...the TEXTSPLIT is a great function. The amazing part for me is the that it accommodates multi-delimiters using the curly braces. Very explicit video. Thanks for sharing Leila
Glad it was helpful!
ua-cam.com/video/1tzjF7L7ajQ/v-deo.htmlsi=vt4Faz_3Ao8c5UOO
Awesome Leila. I have learned new formula
This is something I can use today. Thanks!!!
Really cool function!
I love all of the samples especially the last one. 🤯🤯🤯
Really cool!!! Looking forward to these foundations!!! Great presentation. Thank you!!!!
Thanks for watching!
Amazing, to the point, accurate and very easy to understand thank you
Glad you think so!
Thanks, quick and clear!..
Your teaching is amazing mam.
This is realy a cool feature, thankyou
After this video lesson ….. I am using this function a lot to clean up my data. Much better than text to col !!!! Thanks a lot for the wonderful video
I love this channel! :)
Holy cow this made my day and blew my mind