Forum Discussion
TextJoin keeps adding double quotation marks - How do I make it stop?
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)
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)
Thank you! Selecting the 3 columns and doing a copy / paste works great. I had been using the TextJoin with a space delimiter and Excel doesn't add the double quotation marks for a space delimiter. Then I re-purposed the code by just substituting the space delimiter with the tab character and the whole output changed!
After some experimenting, it seems Excel wants to quotation anything that has a non printable character:
9 tab
10 line feed
13 carriage return
Thank you,
Barclay