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!
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.
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!
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
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.
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!
It's killing me waiting for these functions!!! I don't want to watch your videos because it makes me sad when I'm working in formulas NOW using the old methods, and the whole time I'm thinking about these delicious new formulas that I don't have yet. :-) Thanks for the info!
Always the best instructor i ever see in RUclips, i m giving excel training to people and your work makes me amazing for that people..you are just hero
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. 😕
Oh, this is outstanding. I have a lot of items that need to be treated as "one word" and I've been using no-break space, but that introduces issues when people search the data (like if somebody goes by "J T" or just a state name like "New Jersey". These functions will clean all that in a hurry.
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! 😊👍
My boss wants me to put a fact sheet together for some Excel tips, this channel is the first place I always go to find ideas on cool Excel tips and tricks to share with my co-workers. I hope you don't mind Leila, but I put the URL to your channel at the bottom of that fact sheet so all my co-workers can easily find your cool tips also.
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!!
❤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.
These new function are really terrific. Good video, Leila! Hot tip: if you want to avoid having to press up-arrow or hunt with the mouse EVERY time you invoke a formula, you can make change the setting in File | Options | Advanced | Editing options and remove the checkmark for 'After pressing Enter'.
Thanks. I used to have that as my default, but I kept getting questions about why my cell doesn't go one down when I press enter, so I changed it back so it's similar to most people. I need to remember to press control enter 😁
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!!
I remember doing a lot of workaround on the raw data that comes from the database of our 3rd party auditor. Imagine the dates (MMM DD YYYY hh:mm:ss) in are in text format with extra spaces in between. 🤦🏻♂️ Boy! It took me a while to get the text formulas functioning. Could've saved a lot of time and smaller file size if this was available back then. Now, I'm hoping to find use case scenarios in my new job. Ha! 😅 Again and again. Thank you, Leila, for sharing your knowledge to us! 😉
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.
Thanks! Whenever I'm stuck, I search your channel first for the solution...and almost always find it!
Thank you! Glad to hear that.
Thanks for your simple, no-nonsense way of explaining. It's always a pleasure to watch your videos.
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
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
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
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.
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Very nice. As an Excel instructor, I'm blown away by the new formauls AND how well you present topics. Thank you
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Thanks
I liked the idea of splitting and re-joining again and it's a really good feature of multiple delimiters
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Thanks!
Thank you!
Amazing function. A great alternative for "text to column" functionality of Excel.
Your videos are very informative and always on point. Thank you!
ruclips.net/video/1tzjF7L7ajQ/видео.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.
Textsplit is a great function - so many possibilities when nested with other functions as you have clearly demonstrated.
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Díky!
Thank you Roman!
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!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
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!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Esta chica es LA MERA RIATA!!!!! I mean when it comes to MS apps, look no further! Mis respetos!!!! and a big GRACIAS!
Leila ,right now I am struggling to find words for thank you but the way you are helping people in their professional problems is hugely admirable 🤲💞
This has just single handedly changed the way I work. Amazing! So much time saved again
Great to hear! 🙌
These videos are never boring... thank you
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!
I’m so pleased and very proud of you when I see 1.68M subscribers??? Did I read that right?? The world has to know! You make EVERYBODY Excel here!! 💋
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
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!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
An excellent explanation. You make the math in the equation so easy to grasp.
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!
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
Awesome Leila. I have learned new formula
It's killing me waiting for these functions!!! I don't want to watch your videos because it makes me sad when I'm working in formulas NOW using the old methods, and the whole time I'm thinking about these delicious new formulas that I don't have yet. :-) Thanks for the info!
This is something I can use today. Thanks!!!
Leila Gharani
I am very grateful to you , you helped me a lot in improving my creativity and productivity at work.
Thanks from Egypt.
Always the best instructor i ever see in RUclips, i m giving excel training to people and your work makes me amazing for that people..you are just hero
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Got here from your udemy course on Macro and VBA. Thank you for transferring your golden knowledge!!!
This makes my job much easier. Thanks for the update.
Thank you for showing this. I've been waiting for this since the 90's! Seriously, it's been that long!
There have been many situations where this would have saved me much time. Thank you.
Same here 😁
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!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Leila, you're amazing! You showed me how to do what I was doing in a faster, cleaner way. Thanks!
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. 😕
Oh, this is outstanding. I have a lot of items that need to be treated as "one word" and I've been using no-break space, but that introduces issues when people search the data (like if somebody goes by "J T" or just a state name like "New Jersey". These functions will clean all that in a hurry.
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 😂😂
I love all of the samples especially the last one. 🤯🤯🤯
The new excel functions including the “textsplit” are just awesome! Thanks for sharing, Laila!👍🏻
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
Yes I wish I had this decades ago! You are amazing.
I have never seen such videos, these are brief very well explained in short time and most importantly free of cost😊
My boss wants me to put a fact sheet together for some Excel tips, this channel is the first place I always go to find ideas on cool Excel tips and tricks to share with my co-workers. I hope you don't mind Leila, but I put the URL to your channel at the bottom of that fact sheet so all my co-workers can easily find your cool tips also.
That is a really powerful function and your example and explanation on how to use it is just brilliant. Very helpful.
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!!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
I have amazing moments, watching your tutorials.
Amazing, to the point, accurate and very easy to understand thank you
Glad you think so!
Ahhhh new tool unlocked! This is what I'm missing in my master list. Thanks.
Excellent, you have cracked it already the new function, Superb, keepit up
One of the best channels to upscale your skills 😊😊😊👍
Very good examples of how we can put TEXTSPLIT to use. Especially the SORT option. Thank you Leila!
ruclips.net/video/1tzjF7L7ajQ/видео.htmlsi=vt4Faz_3Ao8c5UOO
I cannot wait to try the new TEXTSPLIT function.
Great! Please continue sharing your knowledge.
Shout out to you ma'am!!!!
I enjoy all the smart videos you post Leila "Guru" Gharani!
Excel does have awesome text functions. This video just shows a few of them! There are many others!
The Text Split Function is amazing in application with ease of use.
Holy cow this made my day and blew my mind
Amazing Excel evolution
❤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.
Your teaching is amazing mam.
Very nicely done!
HOLY COW!!!! So very cool!
These new function are really terrific. Good video, Leila! Hot tip: if you want to avoid having to press up-arrow or hunt with the mouse EVERY time you invoke a formula, you can make change the setting in File | Options | Advanced | Editing options and remove the checkmark for 'After pressing Enter'.
Thanks. I used to have that as my default, but I kept getting questions about why my cell doesn't go one down when I press enter, so I changed it back so it's similar to most people. I need to remember to press control enter 😁
It's no wonder why you have so many subscribers. Great video, thank you.
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!!
Congratulations # You earn a subscriber. Because of your to the point and simple explanation.
Thanks for the sub!
Thanks for explaining in simple way.
This is a great channel, thanks for all this information!!!
Leila you are amazing! I have been watching your tutorials & I just love you!
This will be fantastic. I'm looking forward to TextSplit being released to all MS365 subscribers. Thanks Leila
Me too!
This will solve a lot of problems, kudos to Microsoft for this solution
You do a great job explaining these!
Thank you for the great examples Leila!
Omg that’s just mind blowing…. What a function !!!! 🤩
Recently learned LET, FILTER, and XLOOKUP from your videos. Very very useful at work!!! Thanks for this one too!!!
Really cool function!
I remember doing a lot of workaround on the raw data that comes from the database of our 3rd party auditor. Imagine the dates (MMM DD YYYY hh:mm:ss) in are in text format with extra spaces in between. 🤦🏻♂️ Boy! It took me a while to get the text formulas functioning. Could've saved a lot of time and smaller file size if this was available back then. Now, I'm hoping to find use case scenarios in my new job. Ha! 😅
Again and again. Thank you, Leila, for sharing your knowledge to us! 😉
I'm sure it will come in handy at some point 😊
Lady, thank you so much. Easy explanation.
Awesomes new excel function, even better the way you presented it. You rock!! Thanks
I love this formula.. So simple and powerful
Thank you for the detailed video regarding TEXTSPLIT :)
Thank you so much for this new function! Can't wait to have this on my 365!
Thank you! Very useful!! Love it!
Thank you Leila! I'll try it tomorrow again on my work! :)
I am never disappointed here
Thats an awesome new function! Thanks for making a video about it!!!
Can't wait to use this the next time.
....very nice - It really makes things a lot easier....
SUPERB - as EVER... THANKS, Leila - Keep up the GREAT work! 👍👍👍
You always PERFECT
Thank you! I've learned something great!
Great information as usual!!
Simply amazing, superbly superb way of describing the much needed information - Loved it.
Glad you liked it!
Really cool!!! Looking forward to these foundations!!! Great presentation. Thank you!!!!
Thanks for watching!
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!
Thank you, Leila! You Are The Best
Thank you Leila!
Extremely clear video!!
Tolle Tipps, klar und einfach präsentiert - vielen Dank dafür und Grüße in meine Heimat