The TEXTJOIN function is one of the newer ones, until Office 2019 exclusively available to Microsoft 365 subscribers, and it allows joining multiple strings into one by specifying them and then defining delimiters and the option to ignore those that are empty. Since august, the TEXTSPLIT function appeared, and its purpose is to split strings. How to use this function you will find out in the “recipe” that follows…
In the “Excel Kitchenette” blog so far you could have met many text manipulation functions. As of August 2022 (unofficially), and officially as of a few weeks ago, Microsoft 365 subscribers have some new functions at their disposal that increase productivity and can help you more easily to retrieve individual parts of a given text, before or after the delimiter.
Version History is a great feature that can be used by all Microsoft 365 subscribers who store files on a SharePoint or OneDrive repository. Storing files in the cloud brings a lot of benefits, one of which is the overview of all versions and the ability to restore a previous version of an Excel document that was worked on by one or more users.
Writing Excel formulas with the help of Name Manager can be a demanding job. When you write simple formulas, you will still somehow manage. With complex formulas or changing existing ones, there is a high chance that you will make a mistake. The LAMBDA feature allows you to create your own functions as names added in the Name Manager, and to make this job easier, Microsoft has created an Excel add-in for creating complex formulas: Advanced Formula Environment.
It is a common practice in domestic retail outlets to keep a large number of items under one code. In fact, it is one item, but its additional attributes are not taken into account, such as: color, size, design, season … Consequently, the stocks are incorrect. How to form item codes in such a way that, within the code itself, all its attributes are taken into account? We will use permutations!