separate data

  1. E

    Splitting Addresses Into Separate Columns

    Hi, I need to separate a lot addresses into two columns. 1 with the Lot, Level and Street part and the 2nd column with the Suburb, State and Postcode. I tried a split column formula but because there are multiple commas and no consistencies, I'm finding it hard to think of something. e.g. Lot...