You can add more formula columns to extract other parts of the values and will work best if the data is standardized. If there's some variation then chatGPT may be best at breaking this information down into different sections instead.
How to Separate Address Parts into Suburb, State, and Postcode in Excel | Clay