Automated data sorting

[Rocketboy.911]

So my problem is i have 3896 data entries each consisting of one cell per entry and each cell has
name street and post code
i want to be able to auto sort them somehow but every code ive tred to make on my own keeps making things worse and I've never gone to any school for excel all i know about it is self tought so i hope someone can teach me their ways of making the most powerful information processing tool work for me as-well.
check my attachment the first row is the info and next 3 rows is what i need to sort into.

 

[Deepak]

There are multiple ways to do so.


B2 = LEFT(A2,FIND(CHAR(10),A2))

C2 =TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",255),2),FIND(CHAR(10),A2)+1,255))

D2 =TRIM(RIGHT(SUBSTITUTE(A2,CHAR(10),REPT(" ",255),2),255))

 

[Rocketboy.911]

There are multiple ways to do so.


B2 = LEFT(A2,FIND(CHAR(10),A2))

C2 =TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",255),2),FIND(CHAR(10),A2)+1,255))

D2 =TRIM(RIGHT(SUBSTITUTE(A2,CHAR(10),REPT(" ",255),2),255))

Teach me your ways

 

[Deepak]

Teach me your ways

loop http://forum.chandoo.org/threads/not-able-to-extract-correct-data-with-the-mid-formula.22592/