Thread: Listing of numbers within different postcode ranges given in one column
View Single Post
 
Old 09-13-2018, 12:09 AM
imohammed imohammed is offline Windows 10 Office 2016
Novice
  
Join Date: Sep 2018
Posts: 1
imohammed is on a distinguished road
Default Listing of numbers within different postcode ranges given in one column
Help please,
I have a listing of postcodes in a col. A with some of them given as a range (see attached). 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
Attached Files
File Type: xlsx PC Range_Zone.xlsx (23.1 KB, 8 views)
Reply With Quote