Microsoft Excel

Microsoft Excel is the most popular spreadsheet program on the market and an essential tool to organize, manipulate and analyze all kinds of data.

How To Join Texts Using TEXTJOIN & IF Functions | Microsoft Excel

The TEXTJOIN is a new function introduced in 2019 and available in Microsoft Excel 2019, Excel 2021 and Excel for M365. The TEXTJOIN function combines the text from multiple strings or range separated by delimiter. While we can use TEXTJOIN to combine the texts , the above requirements cannot be achieved alone with TEXTJOIN as we need to combine the data for each user separately. Hence we need to use TEXTJOIN and IF functions together to achieve the desired result.

Excel Text Join
Scroll to Top