One way which might suffice, presuming data as posted is representative

Assuming data in A1 down

Put in B1, copy down:

=IF(A1="","",IF(ISNUMBER(A1),A1,LEFT(A1)+CODE(LEFT (A1))/10^10))

Then select both cols A & B, sort by col B, ascending

--

Max

Singapore

http://savefile.com/projects/236895
xdemechanik

---

"Terry Bennett" wrote in message

...

Is there a way I can sort numbers such that if I have a letter suffix (ie;

2A, 3B, etc), they are sorted after the original number, ie; 2A between 2

and 3 then 3B between 3 and 4?

Thanks.