| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Little Problem, Difficult and Hard. | Excel Discussion (Misc queries) | |||
| A Difficult Unconcatinate Problem | Excel Discussion (Misc queries) | |||
| A difficult problem - Excel 97 | Excel Discussion (Misc queries) | |||
| Difficult Excel Problem | Excel Worksheet Functions | |||
| Difficult Sorting Problem | Excel Discussion (Misc queries) | |||
![hans[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
