How to Separate Address Parts into Suburb, State, and Postcode in Excel

·

Hello, I am trying to separate the address parts after each comma into suburb, state and postcode (see in image) In what formula is this done?

GEM R.
·
·
https://clayrunhq.slack.com/files/U06CART3UKD/F06CD9X1E11/new_note.jpeg
Clay Team
APP
·
·
Hey, thanks for reaching out! Taking a look. It does appear that you were able to separate part of it already though, right?
Clay Team
APP
·
·
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.