Ask Your Question

Textjoin not working correctly

asked 2019-02-12 17:32:54 +0200

chrisboat gravatar image

updated 2019-02-12 17:34:45 +0200

I think that TEXTJOIN is not working incorrectly or i just don't understand it .. Can anyone help clarify I show what I get vs what I think I should get in the attached spreadsheet

C:\fakepath\sample 1.xlsx

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-12 18:10:26 +0200

chrisboat gravatar image

Solved this. Did not understand that I needed to end the formula with Ctrl, Shift, Enter to turn the formula into a Dynamic Array Formula. Yhen it works just fine.

Corrected sheet attached

C:\fakepath\sample 1.xlsx

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-12 17:32:54 +0200

Seen: 96 times

Last updated: Feb 12