Sorting in excel 2003

  • Thread starter Thread starter stainless
  • Start date Start date
S

stainless

I have a column of values that are numeric but also
include numbers
followed by a letter e.g.

1
1a
2
3
4
4a
4b
5

I want to sort into this order, by number first but
ensuring that 1a
follows 1 and is before 2. If I sort as numbers, this
will not work
and sorting as text also does not work. Any ideas how I
do this?
 
You will need a helper column

If your data is in column a then in b1 insert formula =LEFT(B1,1)

copy formula down

sort by column b then
 
Back
Top