Saving selection with values separated by ; as CSV file in one column

[drrazor]

Hello,
I've got following problem. I'm trying to save selection from one workbook to new workbook and save it in csv format, I'am using this formula:

Please Login or Register  to view this content.

I'm trying to copy cell containing lets say:

Please Login or Register  to view this content.

but this function spreads it to separate columns and deletes ";", how can I avoid it? And have it in one cell?

Thanks in advance for help!

[ranman256]

1. If the cell has that text (above) with SEMIs in it then you cannot save to CSV with semis as separators too.
2. If you are not using semis as separators, then you cannot open the file in excel because it will (by default ) recognize them as separators anyway.
3. You could try using " as string containers.

[drrazor]

I deleted for a moment .Close (False) and saw that conversion is done during saving file, it copies normally.

[drrazor]

The thing is ranman256 that I can save file manually with semis as separators, but when using macro it separates them automatically.

[drrazor]

bump, its very important