seperating an address by street address, unit #, city, state and zip that has no commas

[michnance]

I have a 15,000 line spreadsheet where the addresses are listed with the street address then unit number then city then state code and zip separated by spaces within a single cell. A1 Example:

23 NW 27th Lane Cape Coral FL 33993 I need the address to split like so: 23 NW 27th Lane Cape Coral FL 33993 <tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

<strike></strike>
After trying myself I have adding all states listed by two letter state abbreviation in column I starting a row A, if that is helpful in anyway. If not, I can obviously deleted column.

I would so appreciate any help getting this split.

All searches are showing how to do it when there is a comma following street address and another following city. PLEASE HELP! ​

​

 

[sandy666]

Sure, here is easier version. You need correct ca. 200 records marked yellow.
addresses