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
Bookmarks