That got it! Thanks. I just have to remenber to keep the two pre concatenate
columns there so I can resort after changes and sort by other columns.
"CLR" wrote:
One way would be to break off the letters using data Text-to-columns
Fixed, and put them in the next column, then sort using your regular column
as the first sort-key and this new column as your second
sort-key............then you could Concatenate them back together if you
wish......
Vaya con Dios,
Chuck, CABGx3
"confused on the tundra"
wrote in message ...
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?
|