Seperating Addresses into columns

[bpatters55]

Hello All,

First time poster and I have a question about how to separate addresses where all the text is in one column. Here are some examples of the addresses (they are fictitious)

100 Colony Drive Fort Lauderdale Florida 33408
150 Bay Street 2nd Miami Florida 33409
175 SE Main Street Fort 3rd Floor Weston Florida 334010

Here is how I would like the information separated into different columns if it can be done.

Column 1
100 Colony Drive
150 Bay Street
175 SE Main Street

Column 2 (If secondary address is present)
Blank - Address 1 does not have secondary address
2nd Floor
3rd Floor

Column 3
Fort Lauderdale
Miami
Weston

Column 4
Florida
Florida
Florida

Colum 5
33408
33409
33410

Thanks, Bill

[Glenn Kennedy]

See the yellow banner (top of screen) and post a sample sheet with REPRESENTATIVE data. The presence of any punctuation in the strings is key to being able to provide a solution (or not!!).