hi
sorry it took me so long to get back. something came up i had to take care of.
but i see you have been taken care of by others. i haven't had a chance to
work on your examples but it would seem you have what you need.
sorry
FSt1

"trans" wrote:

That's exactly what I needed. Thanks a lot.

"Ron Coderre" wrote:

Try this:

First, put your start/end values in A1:B5
99332 99333
99343 99350
99356 99357
99359 99363
99401 99403

Then....
D1: =MIN($A$1:$A$5)

This formula is broken into sections for readability
D2: =IF(MAX($D$1:$D1)=MAX($B$1:$B$5),"",
IF(ISNA(MATCH(D1,$B$1:$B$5,0)),D1+1,
INDEX($A$1:$A$5,MATCH(D1,$A$1:$A$5,1)+1)))

Copy D2 down as far as you need.

Note: if there are to be leading zeros, you'll need to reformat those cells
to show them.

Using your example, those formulas return:
99332
99333
99343
99344
99345
99346
99347
99348
99349
99350
99356
99357
99359
99360
99361
99362
99363
99401
99402
99403


Is that something you can work with?


--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"trans" wrote in message
...
I am looking for a way to break up a range into separate cells. For
example,
I have a range of zip codes in one cell that looks like this: 99359-99363
I
would like that to break into 5 cells, with values of 99359, 99360, 99361,
99362, and 99363.