Odds and Evens

[Jwisner567]

I am trying to figure out how to separate odds from evens on numbers that look like 002-002-002-1. The problem is i need the next to last digit to be the one it separates by. Does anyone know how to do this?

[#2]

@Jwisner567 

In another column, enter the following formula in row 2:

=ISEVEN(MID(A2,LEN(A2)-2,1))

Fill down.

You can then sort and/or filter on the new column.

[#3]

That worked. Thank you so much.