Forum Discussion

Barclay0x00's avatar
Barclay0x00
Copper Contributor
Jul 21, 2020
Solved

TextJoin keeps adding double quotation marks - How do I make it stop?

Good Morning,   TextJoin keeps adding double quotation marks.  How do I make it stop? The cell E3 contains the formula  =TEXTJOIN(CHAR(9),TRUE,B3:D3)   Example: B3      C3             D3 1    ...
  • mtarler's avatar
    Jul 21, 2020

    Barclay0x00  depending on the "other" application you might have options there to keep source formatting or merge formatting, etc...  But if you want to have tabs added, you might be better off just having the text in consecutive columns and then copy the row and paste it.  Or in your example, no text join necessary, just select B3:D3 and copy and paste (if pasting into word, select paste text only)

Resources