I saw a previous post about sorting odd and even numbers, and the formula
generates an "E" or an "O". I need to sort odd and even street addresses. I
could extract the number out of the address and do it that way, but if I just
want the formula to examine the first 1 thru 5 characters in the street
address string and generate the E or O, how would I do that? Is there a way
to examine just numbers and not other text, since I may have house numbers
from 1 to 5 digits?