Hi All,

This is the first time I have posted on here but I am kinda at my wits and I am currently working to correlate some data out of a .CSV generated from a database. The Problem with this report is that in the with a particular product in the report field labelled locations shows the locations as 3 postcodes joined together.

For Example

200027602200

What I need to be able to do is convert this into the below information

Sydney, Colyton, Bankstown

Here is a little more info for you all Australian post codes are 4 digits and also with this report there are some products that only have one or 2 postcodes as per the below examples:

3 Post Codes
200027602200

2 Post Codes
20002760

1 Post Code
2000


For each one of these examples I need the data to come back with in once cell:

3 Post Codes
Sydney, Colyton, Bankstown

2 Post Codes
Sydney, Colyton

1 Post Code
Sydney


Yes I do have a list of all Australian Postcodes and their names.

Thank you all for any help