View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hans[_3_] hans[_3_] is offline
external usenet poster
 
Posts: 41
Default 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