Extract Data Between Carriage Returns

**nycstinger** · 09-09-2009, 11:00 AM

I have a cell that contains several carriage returns. How do I extract data from between 2 carriage returns?

Thanks.

**DonkeyOte** · 09-09-2009, 11:18 AM

A workbook with a few samples might help - with desired output.

Perhaps in the interim something like:

Please Login or Register  to view this content.

Where A1 holds string ... or pending length of phrases between carriage returns another alternative might be:

Please Login or Register  to view this content.

**GuruWannaB** · 09-09-2009, 11:19 AM

I recorded this macro.

Please Login or Register  to view this content.

I had text in A1:A3 that had multiple carriage returns in each cell. The macro does a FIND REPLACE (CTRL+H) and replaces all carriage returns with a "/" - then does a TEXT to COLUMNS. I had to do the FIND REPLACE first, since you cant do a Text to Columns using a carriage return as a delimiter.

Tweek it to your needs.

Hope this helped,

GWB

**NBVC** · 09-09-2009, 11:22 AM

I thought this was being answered here?:

http://www.excelforum.com/excel-gene...reet-name.html

**nycstinger** · 09-10-2009, 07:55 AM

Originally Posted by NBVC

I thought this was being answered here?:

http://www.excelforum.com/excel-gene...reet-name.html

This question is from a different project and I didn't realize the similarities until I saw your reply.

**nycstinger** · 09-10-2009, 08:03 AM

I ended up using the following solution where G2 is the cell with the string:

Please Login or Register  to view this content.

It essentially says the following:
(1) If the cell has 2 carriage returns then (2) find the space number of the second one by substituting a "-" for the returns, (3) find the space number of the first one and (4) return what's between them.

**megnicd** · 12-30-2013, 11:54 AM

I have a similar issue to nyc stinger - I have numerous cells with data seperated by carraige returns, and would like to seperate each line of text into a cell of its own. A formula would definitely be preferred over code!

**arlu1201** · 12-31-2013, 08:10 AM

megnicd,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.