Exporting data containing CrLf

Question

I export query (built on-the-fly) data to a text file using DoCmd.TransferText acExportDelim.
Some fields contain CrLf.
When imported into Excel, each CrLf is considered a new row (even though the field data is wrapped in quotes), so the import is basically a mess.
I've tried replacing CrLf with Lf (or Cr), however, it seems that DoCmd.TransferText exports CrLf anyway.
Any ideas for a workaround?

Answer 1

Some clients like MS Excel support Cr-Lf within data, but only when you enclose it with quotation marks, like here "Test4 CrLf Test5"

Test1;Test2
Test3;"Test4
Test5"