How to export CSV with embedded commas?

[Steve Tyron]

I have never cared for CSV text, preferring tab-sep text instead. I must
have missed some detail because I never learned how to export CSV text
when some of the information requires a comma? I have tried replacing
existing commas with a strange character (œ), then ding a find/replace
after the data is in its new location, but that just seems tedious!

I have to upload a CSV file to an online shopping cart; I have no choice
but CSV. What is my method?

Thanks,

Steve