Try the following...
C2, copied down:
=IF(D2="",B2,--SUBSTITUTE(B2,D2,""))
D2, copied down:
=IF(ISNUMBER(--B2),"",RIGHT(B2))
Then select Columns B, C and D, and sort by Column C and D...
Data Sort Sort by "Column C" Then by "Column D"
Hope this helps!
In article ,
"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?
|