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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top