Extracting address information from one cell

I need a formula that will extract the address, city, state, zip from one cell and paste into another. Different ones in each cell but are always the 3rd line of words in each cell. For example,

1512 Long St
Atlanta GA 30056
Steve H. Baseball Field

I want everything except "Steve H. Baseball Field" to be moved. All 3 lines above are in one cell together.

So you want Address, City, State, and Zip in 4 separate cells?

If so, try these (Assuming that the string is in A2):


Address (B2) =LEFT(A2,FIND(CHAR(10),A2)-1)

City (C2) =SUBSTITUTE(TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",100)),100,100))," "&D2&" "&E2,"")

State (D2) =MID(A2,FIND(E2,A2)-3,2)

Zip (D2) =RIGHT(TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",100)),100,100)),5)