hi sudkool:

If the address is in A1 assuming that there are no extra characters on the
end:

[A3] line 1=LEFT($A$1,FIND(CHAR(10),$A$1,1)-1)
[A4] line 2=MID($A$1,LEN(A3)+2, FIND(CHAR(10),$A$1,LEN(A3)+2)-1-LEN(A3))
[A5] town=MID(A1,LEN(A3)+LEN(A4)+2,LEN(A1)-LEN(A3)-LEN(A4)-11)
[A6] state=MID(A1,LEN(A1)-7,2)
[A7] zip=RIGHT(A1,5)

You could use formula to find the places of the , in the last line but I was
being lazy.

You can have a try if you like.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"sudkool" wrote:


Hi,
I have full address in once cell and I was just wondering if there any
way to un-concatenate it in all different cells. Here is the example

Cell A1

16545 Dingo St
suite 656
Chicago, IL 54545

Please help me if you know how to save all of that cell into 5
different cells (address1, address2, city, state, address).

Thank you so much in advance




--
sudkool