How to extract words in excel?

This can be done, but it is a tedious process. As a start, you can go to the menu item Data | Text to columns… and tick the space box to use as a delimiter. This will separate each word into a separate column, but the problem is then that with road names of different sizes you will find that the town and zip code do not line up.

I recommend that you go back to the original data and separate the data with commas, as in

123,Main Street Avenue,Anchorage,ALASKA,99501,UNITED STATES

You can then use the text to columns feature with the comma as a delimiter, and everything will line up perfectly.

this solution relies on the address being constructed using ALT+ENTER (linefeeds)

A2 is adddress

A4 =SUBSTITUTE(A2,CHAR(10),"#")

A6 =MID(A4,FIND("#",A4)+1,LEN(A4))

A8 =MID(A6,1,FIND("#",A6,1)-1)

A10 =CONCATENATE(LEFT(A8,FIND(" ",A8)), RIGHT(A8,5))

ZIP is assumed to be 5 digits, and only extracts single name locations (state name creates problem with multi name addresses).

Hope this is of some use.

For the city you could try

=MID(A1,FIND(CHAR(10),A1)+1, FIND(",",A1)-FIND(CHAR(10), A1)-1)

For the zip

=MID(A1,FIND("^", SUBSTITUTE(A1&CHAR(10),CHAR(10), "^",2))-5,5)