That does work. However, there are 2000 of these instances, and they do not
all have the same length of range. Any suggestions for a case like this?

"FSt1" wrote:

hi
if the long zip is in A1 then in B1 put...
=left(A1,5)
then in C1 put
=B1+1
copy and paste in D1 and E1

worked for me
Regards
FSt1
"trans" wrote:

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.