Sorting

  • Thread starter Thread starter tarynnl
  • Start date Start date
T

tarynnl

I have a column that contains the following data

concept1
concept3
concept10
concept20
concept30

etc...

i want to sort this column but when i do it changes to

Concept1
Concept10
concept20
concept30
concept3

how do i sort it by the values??
 
Tarynnl,

The key is to use a helper column: if your 'concept##'s are in column
A, starting in A1, then in B1, use the formula

=VALUE(MID(A1,8,3))

The last 3 could be a 2 if you don't expect concepts over concept99,
or a 4 if you expect concept1000 and up.

Anyway, copy that formula down to match your data, then sort on the
formula.

HTH,
Bernie
MS Excel MVP
 
thanx

but it seems to take the word concept out is there a way i can keep
concept at then the number??

Tarynn
 
tarynnl,

You need to take the word concept out to get the numeric sorting that
you require. You don't need to keep the extra column, or even show
it, but you have to have simple numerics.

Alternatively, you could enter your word/numbers as

concept01
concept02
....

and Excel will sort those properly with no extra formulas or columns
needed.

HTH,
Bernie
MS Excel MVP
 
Back
Top