Splitting an address into parts

[Dan_Barak1]

This example may be useful:

Extracting Addresses

Hi! I'm trying to pull addresses from a form, but the wording changes every time so I'm not sure if it's possible. Any ideas of how to automate this process? The information is always in two cells of the chart. Two example formats: STORE NAME #11 STATE UNIV BKST 1111 EXAMPLE STREET CITY NAME STATE ABBREVIATION ZIP CODE First Name Last Name, 1111 Street Name, Building Room Number 111, (123)-123-1234, email.address@college.edu Here's what I have so far. The city, state, and zip Code are in sep…