Excel as .txt file

Hi,

This might be a shot in the dark as it not strictly .xlsx-related but I thought I'd give it a go.

For running scripts with our main database, I prepare a two-column spreadsheet and save it as a tab delimited .txt file. If one of the cells contains a text string, this is transformed into a " text string " in the .txt file (with quotation marks) but only if it contains a comma. The text in quotation marks is needed for running scripts successfully, so we would ideally want all cells to be transferred with quotation marks. I have tried (with ="symbol"&cell1&"symbol" and copying over the value rather than the formula into the file) to make non-comma-containing cells adopt the quotation marks in the transfer to .txt but this solution has only led to the quotation marks being doubled or tripled in the .txt file which stops the script from running.

Is there a way the formatting of the cell could be changed to stop this from happening?

Apologies if this is not your area of expertise - if you know anyone who might be able to help with .txt-related things, do let me know and I'm happy to contact them. I appreciate this is a bit outside the Excel realm.

Many thanks for your help in advance,
Isabel