Hello,
Im trying to separate a text in a field and want to use the option “other”. In the text there are a number of CR’s (carriage return). I tried several different unicode options but nothing works.
Is there a way to do this?
regards,
Guy
In CSV a carriage return is always a field separator and row separator, unless it is embedded in a quoted text field. There is no need to specify it. If you wanted to use it to split multiple lines of text into columns when doing Text to Columns, that is not possible.
However, in that case you could use a formula
=SUBSTITUTE(A1;CHAR(10);"|")
(or any other character instead of | that is not used in the text) and on the resulting cell use Text to Columns specifying | as other separator.