Рет қаралды 200,879
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