Hi Peter

That is exactly my issue as suburbs can have the same postcode so l cant use the whole postcode. Each suburb must have it's own unique 4 digit code and l then have the other issue of suburbs that start with the same letters and are in the same state. Can Excel generate a unique codes? Even if it a number or a combination of numbers and letters?