"Domenic" wrote:

Try the following...

C2, copied down:

=IF(D2="",B2,--SUBSTITUTE(B2,D2,""))

This populated column C with values from B until it got to the numbers with
the letter suffix and put #value with the little triangle in the upperleft
corner.

D2, copied down:

=IF(ISNUMBER(--B2),"",RIGHT(B2))

When I do this no numbers show up in the any of the cells but the formula is
in the Fx box on the tool bar for all the cells.

Then select Columns B, C and D, and sort by Column C and D...

Data Sort Sort by "Column C" Then by "Column D"

When I sort it stays the same as before with the number with suffixes on the
bottom.


What am I doing wrong?


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......
BINGO! that did the trick. Thanks
Vaya con Dios,
Chuck, CABGx3