How to take sequential values with breaks and convert into high/low ranges

zruhland

New Member
Joined
Aug 23, 2012
Messages
1
I have zip codes in a single column and they do not increase incrementally by one each time. There are gaps in the sequence. I am trying to split this zip-code column into two, the low # and the high #.

This is the current state:
Zip-codes

73442
73443
73444
73446
73447
73448
73449
73451
73452

This is what I want it to look like:

Low High
73442 73444
73446 73449
73451 73452

Any suggestions would be very much appreciated. Thanks in advance!
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,095,365
Messages
5,444,032
Members
405,262
Latest member
palash1010

This Week's Hot Topics

Top