Search code examples
excelexcel-2007excel-365

How to replace TEXTJOIN() in Excel for older versions?

I have an Excel sheet that works well where I use TEXTJOIN() which is only available in the latest Excel versions. Is there an easy way to transform it to use existing functions of older Excel versions?

My code looks like this:

TEXTJOIN(", ";TRUE;IF(INDIRECT("'"&C5&"'"&"!$E$88:$E$239")="Yes";INDIRECT("'"&C5&"'"&"!$D$88:$D$239");"")
Solution

  • Try to combine the formulas IF() and CONCATENATE()