AltSearch never worked in Calc.
Standard F&R has no means to use hard line breaks in replacement strings.
Since long we have the absurd situation that
\n in the 'Search for' is representing a hard line break while the same
\n in 'Replace with' represents a paragraph break.
Concerning the insertion of characters via their unicode CodePoint in replacement strings: Otherwise found specifications prefer \uHHHH or \UHHHHHH (3-byte-codepoints) respectively.
Calc cells never accepted paragraph breaks.
(Though the API method, when creating an enumeration of a
Calc cell as Text is treating U+000A as if it is a paragraph break.
And though the insertion of Char(13) into a string to return by a formula is accepted, but has no influence on the rendering.
Office software seems to regard
consistent inconsistency as its raison d'être.)
To get your desired view use something like =SUBSTITUTE(A2;", ";CHAR(10)) in a spare column.
With 'Copy' and 'Paste Special...', 'Text' only you can later put the results where you want them.
Your example "data1, data2" is suggesting you have something like compound data in a data-keeping spreadsheet application.
Compound data are bad independent of whether they are displayed in one line or more. Multiline display may even be a bit worse as it doesn't even clearly show the character(s) used as separator.
Don't continue this way. SPLIT YOUR DATA! Use 'Text to Columns...' for the purpose as already suggested. But keep the split persistent.
Study
viewtopic.php?f=9&t=96456 to see deterrent examples.
If you urgently want multiline compounds in "prettyprints" or need them to comply with a prespecified format (like for addresses) you can easily concatenate them. Working with data needing a split first is a nightmare.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München