Clay Icon
Join the Community
02 Support

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

Avatar of GEM R.GEM R.
·
·

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?

3 comments

  • Avatar of Clay Team
    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?

  • Avatar of Clay Team
    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.