Creating text file via VBA and need double quotes around several columns

[kweaver]

After a number of calculations and manipulations, I have a sheet which ultimately needs to be saved as a txt file.
That's no problem.
However, there are several columns (some of which are numeric and some are text) that need double quotes around them (front and back).
So, if a column has: 23467, I need the result to be: "23476"
I'm able to do that using CHR(34), but when the sheet is save as a txt file, that process throws two sets of double quotes on the front and back.
In this example, the resulting text file column has: """23476""" in it.

As an example, here's the sheet with the quotes I've concatenated on both sides in column B.
But, as I said, when it's saved as a txt file, I get the above add'l quotes.

Book48
	A	B	C	D	E	F	G	H	I
1	01/07/2021	"23467"	10		38024	REG			6.00
2	01/07/2021	"23467"	10		38105	REG	CARP		2.00
3	01/07/2021	"23467"	10		38105	OT	CARP		1.00
4	01/04/2021	"23467"	10		28024	REG	LABOR		2.00
5	01/04/2021	"23467"	10		38225	REG	CARP		2.00
6	01/04/2021	"23467"	10		38225	REG	GLAZ		4.00
7	01/04/2021	"23467"	10		38225	OT	GLAZ		1.00
8	01/05/2021	"23467"	10		38105	REG	CARP		5.00
9	01/05/2021	"23467"	10		38106	REG	IRON-ORN		3.00
Reformatted

 

[kweaver]

Bump.
Any suggestions or is this impossible?