Carriage Returns

**Highbury_White** · 02-24-2010, 08:26 AM

Hi,

Just wondering if someone could help me. I have a cell whereby I have an address. The address is split into 4 lines. Is there anyway I can copy each line to a new cell e.g

if Address is in A1, top line goes to B1, 2nd line to C1, etc

Any help would be greatly appreciated

Regards

Robert

**JBeaucaire** · 02-24-2010, 08:28 AM

Mockup a sample workbook showing a few rows of the data and your desired results, point out where the results came from if not obvious in your sample data.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**Highbury_White** · 02-24-2010, 10:00 AM

Originally Posted by JBeaucaire

Mockup a sample workbook showing a few rows of the data and your desired results, point out where the results came from if not obvious in your sample data.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

I have attached a file, A1 is the cell I have, A5 is what I would like to appear

Thanks

**JBeaucaire** · 02-24-2010, 10:09 AM

In B1:
=LEFT($A1, FIND(CHAR(10),$A1)-1)

In C1:
=MID($A1,FIND(CHAR(10),$A1)+1,FIND(CHAR(10),SUBSTITUTE($A1,CHAR(10),"|",1)) - FIND(CHAR(10),$A1))

In D1:
=MID($A1,FIND(CHAR(10),SUBSTITUTE($A1,CHAR(10),"|",1))+1,LEN($A1))