can you sort numeric address numbers by even/odd

[FireBrick]

You guys gave me the clue on how to change Text to Columns.
Now I looked through the help file
I can't figure out how to sort the address numbers
even/odd
4556
4558
and then when done
4551
4553
etc.

please and thanks in advance


--


-----------------------------------------------------
Tennessee State Motto: The Educashun State
-----------------------------------------------------

Bill H. in Chicagoland
webcams at http://76.16.160.118:8080
weather at http://hhweather.webhop.org
web blog at http://vote4billheinzinger.blogsport.com

 

[Dave Peterson]

If all you have in that field is the address number, you could use:

=mod(a2,2)
and drag down.

Then sort your range using that field as the primary key.

But what about apartments 4556.5 <vbg>.

 

[FireBrick]

But what about apartments 4556.5 <vbg>.
there are none. lol lol
thank you