How do I return text in between char(10)

[Dave L]

I have a cell with multiple instances of char(10). In one cell I want to
return the text in between the first and second instance of char(10), in the
next cell I want to return the text in between the second and third instance,
etc. I've been playing around with mid and substitute but can't get it to
work right. Any suggestions?

 

[Dave Peterson]

If your data is in a single column, maybe you could use Data|text to columns.

Select the range/column
data|text to columns
delimited
and type ctrl-j (hit the control key and j) in the Other box
and finish up the wizard.