I have a column that has blanks, characters, numbers, number w/ text attached
and text. When I sort (selecting sort with numbers and numbers stored as text
separately) the order items are returned in is : blanks, characters, numbers
and numbers w/ text mixed together, then text. I want to be able to sort so
my numbers and numbers w/ text appear first. Please advise if possible.

For example:
Sorting: current sort
#
(this is a blank)
123
123A
HOME


Desired Sort:
123
123A (these two can be interchangeable)
#
HOME
(blank) (these bttm 3 can be interchangable)

TFTH