Sorting in excel 2003

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?
 
M

mudraker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . 6
Sorting several columns 1
SORTING 1,1A,2,3,4A 2
Numerical Sorting 1
sorting numbers and numbers that contain text in excel 2
Number generator and combination 1
sorting alphanumeric text 4
Sorting number in multiple rows 4

Top