Use IF with text and numbers You can use text or a number for the test and text or a number for each result. Again, this gives you great flexibility with the IF function in Excel.

TEXTJOIN function is available in Excel for Office 365, Excel 2019, and Excel 2021. The syntax of the TEXTJOIN function is as follows: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Where, ...

Overview Mastering top Excel formulas saves hours of manual work and boosts efficiency.Learning Excel formulas and functions ...