How to seprate address

Hello Friends,

I received a file where address are merge. which i want to break in such a way that,
Please see the below that actual data receive:

Please Login or Register  to view this content.

i just want to break it like Add1=First Line of Address, Add2=Second Line of Address, Add3=Third Line of address.

Please suggest me

Try

=MID($A$1&"^",FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",ROW(A1))),FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",ROW(A2)))-LEN(LEFT($A$1,FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",ROW(A1))))))

Copy down

In b1
=LEFT($A$1&"^",FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",COLUMN(A1))))

In c1
=MID($A$1&"^",FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",COLUMN(A1))),FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",COLUMN(B1)))-LEN(LEFT($A$1,FIND("^",SUBSTITUTE($A$1&"^",CHAR(10),"^",COLUMN(A1))))))
Copy across