All articles with 'Textjoin()' Tag

Excel text functions are essential for cleaning up data, extracting parts or combining results. Learn the most important functions and their usage in this article.

9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.

In this article, I explain about powerful excel features like FILTER(), SORT() and CONCATENATEX() to create a similar 9 box talent map grid for your data.

Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.

We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.

Risk comes from not knowing what you are doing. Warren Buffet If you ever ask a project manager what they are up to, they will tell you “I have no idea“. So risks are quite common in project management. That is why I made this awesome free Excel risk map template to keep track and […]

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.