ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   difficult problem (https://www.excelbanter.com/excel-programming/317867-difficult-problem.html)

hans[_3_]

difficult problem
 
The data i get is the following


NIJMEGEN (4) Gelderland 6215 postcodes
LENT 6663 - 6663 (174)
NIJMEGEN 6500 - 6546 (5931)
OOSTERHOUT GEM NIJMEGEN 6679 - 6679 (105)
RESSEN GEM NIJMEGEN 6683 - 6683 (5)


I need a macro that can change this data in

Nijmegen 6663
Nijmegen 6500
Nijmegen 6501
Nijmegen 6502 etc etc

The numbers like 6500 - 6546 are postcodes and mean that ther als postcodes
from 6500 to 6546
What i need is tha all these codes are put one by one on a separet row.

Is this posible?

Greetings Hans



DMoney

difficult problem
 
Is the data you get in one column or tab delim??



"hans" wrote:

The data i get is the following


NIJMEGEN (4) Gelderland 6215 postcodes
LENT 6663 - 6663 (174)
NIJMEGEN 6500 - 6546 (5931)
OOSTERHOUT GEM NIJMEGEN 6679 - 6679 (105)
RESSEN GEM NIJMEGEN 6683 - 6683 (5)


I need a macro that can change this data in

Nijmegen 6663
Nijmegen 6500
Nijmegen 6501
Nijmegen 6502 etc etc

The numbers like 6500 - 6546 are postcodes and mean that ther als postcodes
from 6500 to 6546
What i need is tha all these codes are put one by one on a separet row.

Is this posible?

Greetings Hans





All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com