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)
SergeiBaklan
Jul 21, 2020Diamond Contributor
To copy the text with tabs into the clipboard without the quotes that's with macro. Couple of samples
https://www.peelonion.com/2017/03/how-to-avoid-extra-double-quotes-excel.html
https://stackoverflow.com/questions/24910288/leave-out-quotes-when-copying-from-cell
- excelTOhtmlMar 24, 2023Copper ContributorThis Crazy why on earth would mircosoft do this?
- Barclay0x00Jul 22, 2020Copper Contributor