Forum Discussion
Barclay0x00
Jul 21, 2020Copper Contributor
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 ...
- 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)
Andrew_Man
Mar 23, 2023Copper Contributor
Just below:
=""""&TEXTJOIN(CHAR(34)&", "&CHAR(34),,H2:H8)&""""
=""""&TEXTJOIN(CHAR(34)&", "&CHAR(34),,H2:H8)&""""