No video

How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project

  Рет қаралды 200,879

Leila Gharani

Leila Gharani

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Extracting certain parts of a text in a cell in Excel wasn't easy. Microsoft recently updated the new TEXTBEFORE and TEXTAFTER functions to make them even more useful. If you need to extract text that occurs before or after a given character or string - this is your solution! I also show you an Excel trick you can use to avoid needing to use nested functions to extract the last delimiter. These new functions also got an update and have more optional arguments you can use. I'll show you how to that in the video.
⬇️ DOWNLOAD the workbook here: pages.xelplus....
Key Highlights:
TEXTBEFORE: Extracts text before a specified delimiter, and you can customize the instance number, match mode, and result if not found.
TEXTAFTER: Retrieves text after a designated delimiter, offering similar options for customization.
Bonus Trick: Learn how to efficiently extract text in reverse order by using negative instance numbers and match to end, making it dynamic and flexible.
🌍 My Online Courses ► www.xelplus.co...
00:00 Extract Text - Split Names in Excel
01:18 TEXTBEFORE
03:53 Bonus Trick
05:36 TEXTAFTER
07:03 Wrap Up
🎬 LINKS to related videos:
- New Excel TEXTSPLIT Function to Separate words with Ease: • New Excel TEXTSPLIT Fu...
- Breaking News! We FINALLY get the Excel functions we've been Wanting: • Breaking News! We FINA...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩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

Пікірлер: 293
@LeilaGharani
@LeilaGharani 6 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/textbefore-file
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@reneberthet9168
@reneberthet9168 Жыл бұрын
That -1 was an aha moment for me! I appreciate you demonstrating the different aspects of the functions so we see how it works. Thank you for your videos! 👍
@LeilaGharani
@LeilaGharani Жыл бұрын
You're very welcome, Rene!
@skimpylemon8034
@skimpylemon8034 Жыл бұрын
@@LeilaGharani Thanks Leila!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@zzota
@zzota Жыл бұрын
You can also combine them to grab a middle element: =TEXTBEFORE(TEXTAFTER(B8, " "), " ")
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@hadinaeem4741
@hadinaeem4741 17 күн бұрын
what if there are multiple things in the middle and i want each one in a different cell, and they're all seprated by ","
@christosmylonas
@christosmylonas Жыл бұрын
You are a great consultant and teacher at the same time!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@AndreaUK1973
@AndreaUK1973 Жыл бұрын
Thanks Sweetie! So glad you test it many times until you find a better way to show us!! Thank you!! It’s not easy to understand the arguments and I think that’s why it puts many people off using some excel functions! As we are constantly under pressure of deadlines, we can’t stop to understand it! That’s why I spend my free time watching your videos!! 😂
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@fpoester
@fpoester Жыл бұрын
I gotta say "thank you" several times for you Leila, many insights on my job these days comes from your videos and makes me find solutions that are a perfect fit to different situations. Keep on and I'll make sure to press that Like button!
@LeilaGharani
@LeilaGharani Жыл бұрын
That’s great to hear! Kudos to you for taking the time to watch and implement.
@suela6404
@suela6404 Жыл бұрын
I have questions, For example, A1 row has name, B1 has dental cost the A2 is blank, B2 Vision amount but A2 is blank. I have 300 employees, Do you have another method not fix row A2 Thanks Sue
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@bluesboynicky6772
@bluesboynicky6772 Жыл бұрын
One thing to add while I was playing around - you can also type in words as your delimiter. I was trying to split a column that had TWO names ex. "John Smith and Jane Doe" into two columns, each with one name. I used " and " as my delimeter and it worked like a charm! Thank you Leila!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@chh8860
@chh8860 Жыл бұрын
Very cool ... and to think all this time I have been avoiding working with people with long titles in their names ... and now I no longer have to do so ... 🤭 Once again, I would have no idea these 'tricks' are available if not for Professor Leila ... thank you ... thank you ... thank you ... 😍
@LeilaGharani
@LeilaGharani Жыл бұрын
Haha, I'm still avoiding them 😁
@wayneedmondson1065
@wayneedmondson1065 Жыл бұрын
Thanks Leila! Great tips. Worth mentioning that these functions will also SPILL and if you want to add the dot that gets removed at the end of the last title, you can use IF, as in: =IF(TEXTBEFORE(A2:A15,". ",-1,,1)="",TEXTBEFORE(A2:A15,". ",-1,,1),TEXTBEFORE(A2:A15,". ",-1,,1)&"."). Thumbs up!!
@sparks1779
@sparks1779 Жыл бұрын
Awesome, I was wondering about the period. Thanks for the tip.
@roderickmose4691
@roderickmose4691 Жыл бұрын
I used =TEXTBEFORE(A1," ",LEN(A1)-LEN(SUBSTITUTE(A1,". "," "))). Substitute 'dot space' with 'space'
@g.r.2985
@g.r.2985 Жыл бұрын
Love your take on the Austrian system!! Gold! That "Eva". eh!! What a "mega collector"!!
@roywilson9580
@roywilson9580 Жыл бұрын
It is about time we had some easy to use text functions! I wish they had been available 5 years ago when I was working on a project that included a lot of text manipulation.
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@vivekphadke16
@vivekphadke16 Жыл бұрын
Excellent, Thanks Leila for updating or shall I say enlightening us ... as always
@LeilaGharani
@LeilaGharani Жыл бұрын
My pleasure!
@handsomecaveman
@handsomecaveman Жыл бұрын
I don't use Excel that much anymore in my daily business routine but, coincidentally, I had a workbook sent to me today and these are the exact functions I used to extract some data from it (+Datevalue). Great job!
@LeilaGharani
@LeilaGharani Жыл бұрын
Perfect!
@Riri-qi2fu
@Riri-qi2fu Жыл бұрын
A pat on the back to all MS Excel team! For the past couple of years, you've done amazing job and making my jobs so easy. Continue to do great work! One request - I would be grateful if you could upgrade 'wildcard formula* for searching text🙏
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@VDash-Slesinski
@VDash-Slesinski Жыл бұрын
Awesome. I work with a team that implements ERP software and sometimes the address lists for vendors and customers come in together. This should make it easier to separate it out.
@LeilaGharani
@LeilaGharani Жыл бұрын
👍
@masonwilliams6562
@masonwilliams6562 Жыл бұрын
Hello 👋👋
@GarthShaner
@GarthShaner Жыл бұрын
Oh the hours of my life in the 1990’s and 2000’s I want back! What a great feature AND a great explanation of how to use it!
@LeilaGharani
@LeilaGharani Жыл бұрын
Thank you Garth. Glad you find it useful.
@jerry5149
@jerry5149 4 ай бұрын
Your presentations are so professional, it's astounding!
@ethofmeyr
@ethofmeyr Жыл бұрын
Always worth watching! Today I even thought, yeah I already know those, maybe I skip this time; but I had no idea about the bonus tip and that could have helped me yesterday. Thank you Leila
@saktibiswal6445
@saktibiswal6445 Жыл бұрын
Awesome functions
@leoceoliveira
@leoceoliveira Жыл бұрын
Very cool! Useful video
@revingmsto5199
@revingmsto5199 Жыл бұрын
Dear Mrs, Leila hopes you are doing well, thank you so much for this inquiry You are a great consultant and teacher
@joeismael9359
@joeismael9359 Жыл бұрын
Thank you Leila, I now understand how some formula works by watching your vidoes 😁😁😁
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@DamiantenBohmer
@DamiantenBohmer Жыл бұрын
THANK YOU SO VERY MUCH, this short formula saved me so much work 😂😂😂
@MichaelColeman_gig
@MichaelColeman_gig Жыл бұрын
I watched this a month ago, and thought it was really cool, but wondered if I would ever need it. Today I did need it, and it save me HOURS!!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@Bhavik_Khatri
@Bhavik_Khatri Жыл бұрын
Very nice tricks.
@unnikrishnansanthosh
@unnikrishnansanthosh Жыл бұрын
simple and super, thank you for sharing
@LeilaGharani
@LeilaGharani Жыл бұрын
You are welcome 😊
@gerbherb8215
@gerbherb8215 6 ай бұрын
Nice! Thank you.
@JeffPospisil
@JeffPospisil Жыл бұрын
This was so awesome! Thank you! I always dreaded the LEFT() FIND() LEN() mess of doing this.
@sandrap.3399
@sandrap.3399 Жыл бұрын
Here's a subscriber from Austria - many thanks for this tutorial^^
@LeilaGharani
@LeilaGharani Жыл бұрын
Hallo Sandra 😄
@fyrman9092
@fyrman9092 Ай бұрын
This is much better and easier than LEFT, MID, RIGHT for multiple instances.
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@Troy-Echo
@Troy-Echo 6 ай бұрын
That worked for my needs. Now I just need to use these to convert dates from a format of 2023-12-19 to 12/19/2023 for Excel to enter the date as I need it. Or figure out a custom format to work that out for me. Thanks for setting me on the path Leila! (Again and again)!!!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@McKaySavage
@McKaySavage Жыл бұрын
Very helpful! Thanks! The search from end argument of these new functions really improves the functionality
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@bajantraian
@bajantraian Жыл бұрын
Hi Leila! Thank you for your videos; they have helped me tremendously at work and in school. I like the way you explain things : easyto comprehend and to the point, with examples! Love you !
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@kickthesky
@kickthesky Жыл бұрын
Leila, you are my go-to person for anything Excel related. I learn so much watching your videos. This was excellent material! Thanks for sharing your knowledge!
@LeilaGharani
@LeilaGharani Жыл бұрын
Wow, thank you!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@eradotcom
@eradotcom 2 ай бұрын
thanks for the enlightenment
@arbazahmad7177
@arbazahmad7177 Жыл бұрын
Thank you for this new text function tutorial.
@LeilaGharani
@LeilaGharani Жыл бұрын
My pleasure.
@edilpoulina1870
@edilpoulina1870 Жыл бұрын
This is an awesome trick Leila. Thanks!
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi Жыл бұрын
Thanks for the share.
@MohAboAbdo
@MohAboAbdo Жыл бұрын
Thank you very much my dear teacher for this wonderful video
@abdulrahmanmuslih141
@abdulrahmanmuslih141 Жыл бұрын
Thanks. It is a great video as usual
@LeilaGharani
@LeilaGharani Жыл бұрын
Thank you!
@JoseAntonioMorato
@JoseAntonioMorato Жыл бұрын
Dear Leila, The TEXTAFTER and TEXTBEFORE functions, unlike the TEXTSPLIT function, work perfectly with selecting an array of text, rather than just a single cell: =TEXTBEFORE(A2:A15,". ",-1,,1) =TEXTAFTER(A2:A15,". ",-1,,1) 🤗
@fawzykitchen1366
@fawzykitchen1366 Жыл бұрын
Huge awesome
@ruthhernandez7295
@ruthhernandez7295 Жыл бұрын
Thank you I learned something new today.
@alparkson5494
@alparkson5494 Жыл бұрын
This is great Leila, thank you.🤓
@moonglumclampflower8803
@moonglumclampflower8803 Жыл бұрын
Really helpful. Very clear. Thanks.
@malcbatotony9518
@malcbatotony9518 Жыл бұрын
Greatly appreciate the knowledge sharing. Thank you so much
@joshuamanampiu6489
@joshuamanampiu6489 4 ай бұрын
Thank you.
@muminatiah547
@muminatiah547 2 ай бұрын
Amazing as usual, really thanks
@bunkosquad2000
@bunkosquad2000 Жыл бұрын
Somebody congratulate me - I just passed MO-201 today! I don’t have any friends or relatives who know what that is!
@AngelStickman
@AngelStickman Жыл бұрын
Sweet. Never new about these functions. I already have a few files in mind to update. Great showcase.
@LeilaGharani
@LeilaGharani Жыл бұрын
Cool, thanks!
@sowjanyakakani6441
@sowjanyakakani6441 Жыл бұрын
U r my great teacher 🙏
@dami5072
@dami5072 21 күн бұрын
Thank you
@garys2187
@garys2187 Жыл бұрын
That was very useful. Especially the -1 to search from right to left.
@LeilaGharani
@LeilaGharani Жыл бұрын
Glad you liked it!
@aliflettmakhutle5184
@aliflettmakhutle5184 Жыл бұрын
Lovely, thanks...
@TroyHowarth
@TroyHowarth Жыл бұрын
Thanks! I didn't know textbefore textafter was a thing. Going to use this trick when I grt into work today.
@helen1599
@helen1599 Жыл бұрын
What excites me way more than new functions, is your gorgeous hair style 😍🤤 dyson?
@LeilaGharani
@LeilaGharani Жыл бұрын
What?! How did you know? But yeah, gave the Airwrap a chance and even I can use it 😁
@helen1599
@helen1599 Жыл бұрын
@@LeilaGharani I just assumed you would somehow automate this process 😛Cannot imagine you with a hot lockenstab, waiting 1 minute for each single hair 😀 Anyway, they should pay you now for the live expo. Looks awesome
@piytube1
@piytube1 Жыл бұрын
Great tips
@Yachid
@Yachid Жыл бұрын
very sophisticated formula use
@mojtabareyhani7905
@mojtabareyhani7905 Жыл бұрын
Great as always, 👍🏿👍🏾👍🏼👍🏻👍👍🏻👍🏼👍🏾👍🏿 Love from Iran.
@Blackshark553
@Blackshark553 7 ай бұрын
very good
@kuuuyajim
@kuuuyajim Жыл бұрын
I'm gonna try this today. I was looking for it last month but it's not yet in my Excel so I had to use other functions. 😅 Thank you for this demo. I learned something new again today. ❤️
@neampdeak
@neampdeak Жыл бұрын
i think so your idea
@smartphoneuser791
@smartphoneuser791 Жыл бұрын
Excellent. You made it very simple. Thank you very much.
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@heimoernstweiss8207
@heimoernstweiss8207 Жыл бұрын
Great functions and very well presented! Thank you!
@LeilaGharani
@LeilaGharani Жыл бұрын
Thanks, Heimo!
@manzarmanu8985
@manzarmanu8985 Жыл бұрын
By the way you taught me 90% of what I know in excel as a matter of fact you taught me power query and that we can add an additional calculated field in pivot....thank you for that
@mohammadj.shamim9342
@mohammadj.shamim9342 Жыл бұрын
Thank you Leila.
@ghgfly
@ghgfly Жыл бұрын
Just wanna know how do you keep your hair so pretty & thick after so many amazing videos uploaded . I dropped off a lot of my hair after loved your video. 😉
@jeanmorin4580
@jeanmorin4580 Жыл бұрын
That'll make it easier to extract the last byte of an IP address (example: 10.34.123.4) ! The hoops I had to go through before: =MID(A2,FIND(".",A2,FIND(".",A2,FIND(".",A2)+1)+1)+1,3) simply replaced by =TEXTAFTER(A2,".",-1) A lot cleaner. For those interested, I managed to get the other bytes using: =INDEX(TEXTSPLIT(A2,"."),2) to get the second byte (change the 2 to get select any byte, which is even cleaner but unlike Leila's method, doesn't check for errors) Thanks Leila!
@scheekostudio6574
@scheekostudio6574 Жыл бұрын
Ms. Leila, I am a fan of yours and learning lot of things from your each and every video. Could you please advise whether we can right a formula for cutting optimizer in Excel if possible? Appreciate it very much.
@AramPirjanian
@AramPirjanian Жыл бұрын
Thanks!
@neampdeak
@neampdeak Жыл бұрын
Thank you for provide this point i will follow your idea in make video that you explainse very exactly
@tonybkent
@tonybkent Жыл бұрын
Excellent! I could have used that yesterday to separate the different parts from an email address. I've always used left / right / len and find instead, but this is much simpler! Thanks!
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@vida1719
@vida1719 Жыл бұрын
Great features and great example. I liked minus one trick
@LeilaGharani
@LeilaGharani Жыл бұрын
Cool, thanks!
@vincentcollin6490
@vincentcollin6490 Жыл бұрын
Clear, as usual !
@doma3554
@doma3554 Жыл бұрын
Very cool KZfaq channel. Excel is so massive, it's hard to find neat tricks unless you're always playing with it and handling weird unique data sets on a daily basis.
@helenb4550
@helenb4550 Жыл бұрын
This is so helpful. I still don't have it on my excel though!
@LeilaGharani
@LeilaGharani Жыл бұрын
You're probably on a semi-annual update plan. It will be there soon :)
@JulioGarciaLx
@JulioGarciaLx Жыл бұрын
Great. Because I needed a Split function so much, I had developed mine in VBA. But I never lost time in solving this type of problem, as it is not very common in the data I work with. I had already stopped using my function and now I have two very interesting new ones. Thank you very much.
@LeilaGharani
@LeilaGharani Жыл бұрын
Hope it will come in handy, Julio.
@jelajahsebanten
@jelajahsebanten Жыл бұрын
Great day my sister
@noush4283
@noush4283 Жыл бұрын
Hello Leila thank you I was looking into this formula to separate the numbers an text . It came handy thank you for the information..
@ramkishoryadav9087
@ramkishoryadav9087 24 күн бұрын
kzfaq.info/get/bejne/bqh_adeb1d_SmYU.htmlsi=MqnxxYGa9WMuOZ1C
@minku1931
@minku1931 Жыл бұрын
Nice, thanks for all this learning seriously
@LeilaGharani
@LeilaGharani Жыл бұрын
My pleasure!
@lachinkhammadov9343
@lachinkhammadov9343 Жыл бұрын
So good function, thanks for Explaining. I found these two formulas a few days ago and using it.
@LeilaGharani
@LeilaGharani Жыл бұрын
👍
@arshadkhundmiri1222
@arshadkhundmiri1222 Жыл бұрын
Really helpful.... thank you 🙂
@LeilaGharani
@LeilaGharani Жыл бұрын
You're welcome 😊
@AhmedKhaliet
@AhmedKhaliet Жыл бұрын
Great as usual thank youuuuuu
@LeilaGharani
@LeilaGharani Жыл бұрын
You are so welcome!
@mariostudio7
@mariostudio7 Жыл бұрын
Wow how did I miss this one
@touchwithbabu
@touchwithbabu Жыл бұрын
Great stuff 1 as always
@chrism9037
@chrism9037 Жыл бұрын
Awesome Leila, thanks!
@LeilaGharani
@LeilaGharani Жыл бұрын
My pleasure, Chris! Hope it will come in handy.
@ricardoluizmarcello
@ricardoluizmarcello Жыл бұрын
Hi Leila!!! Love your videos!
@LeilaGharani
@LeilaGharani Жыл бұрын
Thank you so much!!
@alannavarrovaldez3117
@alannavarrovaldez3117 Жыл бұрын
Nice trick!
@newtonraphsons
@newtonraphsons Жыл бұрын
Thanks
@samirawati1975
@samirawati1975 Жыл бұрын
Hi, what we can do if we want . After that Dr., Please explain, very useful video, thank you so so much
@vijayarjunwadkar
@vijayarjunwadkar Жыл бұрын
Thanks Leila for this cool and useful trick! As an "insider" you could try it BEFORE, but I will have to wait to try it AFTER, when released in "general"! 😁
@LeilaGharani
@LeilaGharani Жыл бұрын
Haha, they're already released though. At least to the monthly update channel.
@vijayarjunwadkar
@vijayarjunwadkar Жыл бұрын
@@LeilaGharani Mine is Semi Annual update...
@iobtax
@iobtax Жыл бұрын
Would not flashfill work>> great video
@mr.brownstone5716
@mr.brownstone5716 Жыл бұрын
I have uses for both these formulas. It's kind of stupid we have to trick Excel with the -1. The formula itself should be set up that way. Lol. Thumbs up!!
@ncoz655
@ncoz655 Жыл бұрын
Simple regular expressions included in Excel. Great to know it has that now.
@markpodesta4605
@markpodesta4605 Жыл бұрын
Thank you Leila. What if you want to include the delimiter for the final title, so it would say 'Dr.' rather than 'Dr'?
@sparks1779
@sparks1779 Жыл бұрын
Wayne edmonson gave us this trick to include the period: =IF(TEXTBEFORE(A2:A15,". ",-1,,1)="",TEXTBEFORE(A2:A15,". ",-1,,1),TEXTBEFORE(A2:A15,". ",-1,,1)&".")
@MrSupernova111
@MrSupernova111 Жыл бұрын
Pretty cool! I like the Excel is adding new functions to simplify our jobs but at the same time I feel like my Excel skills become less relevant each time they add new functions. I wonder if VBA users are also impacted by these new functions as Excel makes it easier and easier to perform complex procedures without the need to learn programming. Great video as usual. Thanks!
@BenSussmanpro
@BenSussmanpro Жыл бұрын
@@b0159673 …and for US Federal employees, this is doubly true, lol!
@alexdemoura9972
@alexdemoura9972 Жыл бұрын
not only because Users don't know, many small business have their sheets on Excel 2007 and 2010. In my experience: sometimes keep the 2007 functions only, the first XLSX version and even sometimes don't use 2007 new functions (such as IFERROR, using IF( ISERROR(... ) to achieve compatibility across different Excel versions in a medium-size company. Also, LOOKUP of any kind (V/H/X) is not advised - in older Excel versions the data need to be sorted, it consumes a lot of memory (and speed) sometimes crashing computers with not enough resources depending on the spreadsheet size - I use one-MATCH-many-INDEX successfully for many years. I like the EXCEL internationalization - functions translated, values formatting - it is the only "computer language" that can reach all the people around the world with a minimum Math & Logic. But when they think about these new functions... they don't listen the Users, they keep the same old logic such as the ones presented in this video, few Excel functions discriminate the same character (or string) in different positions... and it is become harder and harder for individuals or small/medium business to adapt all their spreadsheet data into this Software as a Service (SaaS) products to people that already paid for their software. Never mind, I'm just letting off By the way, the VBA Users can call these new functions as "cell operations" just like any other Excel function if they want to, but VBA itself is not impacted on any way - they said the VBA development reach to an end months (maybe few years) ago - there is no VBA function, command or procedure equivalent to many new Excel functions - if we want to use these new functions in a VBA program we must call them from the spreadsheet which the VBA program is attached to, related to the cells not to the VBA variables.
@keosarin00
@keosarin00 Жыл бұрын
@@b0159673 funny how you brought up xlookup. I never used it but earlier today for work I had to learn it and used it. It saved me so a lot of time.
@dominiquehandelsman9333
@dominiquehandelsman9333 Жыл бұрын
excellent
@utarinuravifah9907
@utarinuravifah9907 Жыл бұрын
Wonderful! Thanks for the video! I love how you could explain the logic behind every formula in the easiest way! If I'm not mistaken, the functions above are one of the features in the Power Query?
@LeilaGharani
@LeilaGharani Жыл бұрын
Glad you enjoyed it! These are regular Excel functions.
@yuanchoy2
@yuanchoy2 Жыл бұрын
Thanks for guide
@Bob_H
@Bob_H Жыл бұрын
Dang, they are cutting into my over-complicated, undocumented, flaky macros! LONG LIVE VBA! Well done video, very informative
@OneEyedOneHornedGian
@OneEyedOneHornedGian Жыл бұрын
This is great! I wonder if they will do the same thing for some other formulas.
@brunosimon6296
@brunosimon6296 Жыл бұрын
Thank you! what type of formula to use to get specific words within a cell to be formatted in red? in order to check which cells contains specific words. Thanks
Effortlessly Create Dynamic Charts in Excel: New Feature Alert!
10:15
Leila Gharani
Рет қаралды 271 М.
Excel's NEW Checkboxes Are Incredibly Cool! Here's why
14:24
Leila Gharani
Рет қаралды 510 М.
WHO CAN RUN FASTER?
00:23
Zhong
Рет қаралды 25 МЛН
Ouch.. 🤕
00:30
Celine & Michiel
Рет қаралды 35 МЛН
ТЫ С ДРУГОМ В ДЕТСТВЕ😂#shorts
01:00
BATEK_OFFICIAL
Рет қаралды 10 МЛН
18 Text Functions in Excel You Need to Know
24:58
How To Excel
Рет қаралды 135 М.
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Leila Gharani
Рет қаралды 433 М.
Excel Functions EVERYONE needs
20:30
Karina Data Scientist
Рет қаралды 620
Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)
12:32
Computergaga
Рет қаралды 4,3 М.
Can you solve these number puzzles?
8:03
MindYourDecisions
Рет қаралды 7 М.
10x Your Excel With This New AI Formula
11:48
Kenji Explains
Рет қаралды 180 М.
The Excel TEXTSPLIT TEXTBEFORE and TEXTAFTER Functions
8:37
Technology for Teachers and Students
Рет қаралды 7 М.
Extract Text Between Two Characters - Brackets or Commas etc
6:24
Chester Tugwell
Рет қаралды 22 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 169 М.