|
|
#1
09-13-2018, 12:09 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Single value on multiple numbers in row into column | T1000 | Excel | 0 | 02-14-2017 11:54 AM |
| Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.) | roderh | Excel Programming | 4 | 09-02-2016 05:12 AM |
 Take String of numbers, expand ranges, sort, then compress back into ranges
|
AustinBrister | Word VBA | 19 | 08-22-2016 05:18 PM |
|
Inconsistent Duration column for the same date ranges
|
ravl13 | Project | 3 | 07-28-2014 05:16 PM |
| Can I auto increase numbers in a column? | compact | Word | 1 | 09-10-2009 07:16 AM |
Windows 10 
Office 2016
Threaded Mode