=TEXTJOIN: Not Returning Text

New Contributor

Hello Everyone,


I am just now learning about the TEXTJOIN function.
I have entered my argument seemingly correctly, as it appears correct in the Function Arguments window.
But it is not appearing correctly in the worksheet cell.

In the attached file, Cell B27 is a TEXTJOIN(...)

Can anyone review and ascertain what the issue is?


Thank you, Alvin

2 Replies
best response confirmed by Alvin_Gregorio (New Contributor)
Change the cell format from Text to General. Then press F2 and ENTER.
Thank You. That works.
I wish I knew why. But Thanks Detlef. -Alvin