How do I return text in between char(10)

  • Thread starter Thread starter Dave L
  • Start date Start date
D

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?
 
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.
 
Back
Top