Forum Discussion
Odds and Evens
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 Replies
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.
- That worked. Thank you so much.
