convert string to 1D or 2D string to write in Spreadsheet

[altenbach]

No, that's not a solution!

If you remove linefeeds from a multiline string, it is no longer a multiline string. You said you wanted a multiline string in a single excel cell, right?

Please let us know if your requirements have changed.

[Arroyo]

Hi,

I probably did not explain myself well enough.... The solution works for me, I simply need to convert the input multiline string into an excel cell which must be, as far as I know, a single-linle string. Well, the Search and Replace does the job properly. 

Just for curiosity,  you meant that is possible to insert a multiline string into a single excel cell?

Greetings

[altenbach]

Yes, it is possible in Excel. It is not possible in simple ASCII tables that use delimiters. As I said, your code has nothing to do with Excel.