Forum Discussion
TEXTJOIN function - Can’t see my error!
I’m trying to display text from one page of a worksheet in a cell on another page, and have tried various things, but keep getting the error #NAME? Please let me know if you can see what is wrong w...
Hi Beth,
If you change quotation mark symbol from “ - CHAR(147) on " - CHAR(34) it shall work
=TEXTJOIN(" ",TRUE,Tops!C2,Tops!D2,Tops!B2)