G
Guest
I have about 1350 5 and 6 digit numbers starting in column B2 that I would
like to be sorted. About 200 of the numbers have "A" at the end along with a
coulpe that have "B", "C", "D", and "E" . All the numbers with a letter are
six digits long if that helps i.e. 123456A. Now when I sort the numbers sort
fine but all the numbers with a letter attached are at the bottom of the
list, presumably as text. How can get the numbers and text"numbers" to sort
together?
like to be sorted. About 200 of the numbers have "A" at the end along with a
coulpe that have "B", "C", "D", and "E" . All the numbers with a letter are
six digits long if that helps i.e. 123456A. Now when I sort the numbers sort
fine but all the numbers with a letter attached are at the bottom of the
list, presumably as text. How can get the numbers and text"numbers" to sort
together?