Listing of numbers within different postcode ranges given in one column

[imran111]

Help please,
I have a listing of postcodes in a col. A with some of them given as a range. Is there a quick way to list the postcodes individually in a separate column within that postcode range given and match the corresponding zone associated with it. Example:

POSTCODE ZONE
200-203 CANBERRA

I would like to this to be:

200 CANBERRA
201 CANBERRA
203 CANBERRA


Thank you​

 

[My Aswer Is This]

Would this be a quick way:

Put 200 CANBERRA in Range("A1")

Put 201 CANBERRA in Range("A2")


Then Select Range(A1:A2")

And then select the small square box in bottom right corner of selection and drag down
​

 

[Peter_SSs]

Welcome to the MrExcel board!

.. with some of them given as a range.

That implies that some of them are not a range, so could you give a slightly bigger set of representative sample data and the expected results?
Preference would be to have sample data that we can copy/paste to test with - my signature block below has a link with suggestions for that.

Is a macro solution acceptable if a formula or manual one is not feasible?

What version of Excel are you using?

A bit of background as to why you want them listed individually might also help.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.excelforum.com/excel-formulas-and-functions/1245270-listing-of-numbers-within-different-postcode-ranges-given-in-one-column.html

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.