Formula to create multiple address fields using data in single field

Hello - i am trying to create a formula that would determine certain data criteria in a single field - if the criteria meets the criteria, then I need to perform actions on that data - if not - the data is left alone. Example of this data is below. I have multiple patterns of data in one column (Address 1) and depending on the data found, I take an action or not ...
Address 1 Address2 City State Zip
2120 Victoria Ln Freeport TX 77541
11400 Bay Area Boulevard Pasadena TX 77507-1712
11499 Bay Area Boulevard, Suite 100 Pasadena TX 77507-1712
P O Box 448 Channelview TX 775300448
P O Box 2487 Freeport TX 77542

1) as you can see above - 2120 Victoria Ln in Freeport TX is the end result of what i need my data to look like - it is 5 fields and I need the address information split out into the appropriate fields
2) I never know how long or the length of each string of data in ADDRESS 1 ...
3) Some Zip codes in the string are 5 characters, some 9 (without the dash) and some 10 (with the dash)
4) Some have Address 2 information like Suite, Room or even a # sign
5) I have over 4500 lines of data which i need to perform this formula action against.

I appreciate any support, suggestions, etc..
Thanks,

Rick Hogan
VP, Sales and Operations

Hi, welcome to the forum

Often, a copy/paste here doesnt quite turn out the way you intended - this is 1 of those times

I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I am probably having "1 of those days" I am not sure what you want. What part if your raw (orginal) data, and which part if your requirement?