New Excel TEXT Functions!
Microsoft 365 announced an array (no pun intended) of new functions! TEXTBEFORE, TEXTAFTER, and TEXTSPLIT are just a few that we will cover in this video.
If you would like to see these features in advance, you'll need to sign up with the Microsoft Insider's Beta Channel by opening Excel and clicking on File, then Account, and finally you'll see "Office Insider" on the right side. I recommend you enable it on a personal computer, since you will receive updates on features that are not ready for primetime.
Chapters:
00:00 - Intro
00:13 - TEXTBEFORE Overview
00:46 - When a tuft of hair really starts bothering me!
02:46 - TEXTAFTER Overview
03:38 - TEXTSPLIT Overview
07:09 - Outro
#textbefore #textafter #textsplit #office365 #Microsoft365 #excel #excel365 #tips #tricks #split text into separate cells
~-~~-~~~-~~-~
Please watch: "Excel Top 5 Flash Fill Excel"
• Excel Top 5 Flash Fill...
~-~~-~~~-~~-~
Пікірлер: 3
I am looking forward to these functions, and more, going live in the near future! Will these functions help you streamline your workflow? If you have any questions about these functions or suggestions for future videos, please comment below! Thanks!
This will be useful for data cleaning to import into a db
@OfficeMystic
2 жыл бұрын
Yes, I'm looking forward to splitting time from date more easily in one of my reports.