I'm guessing this is because your version of Excel doesn't support TEXTJOIN?
In the attached is a one-line user-defined function called txtjn which will do for your purposes, along with a tweak to the previous formula, which, like the previous one, needs to be array-entered (using Ctrl+Shift+Enter, not just Enter).
See attached, cell E2 and below.
|