sorting data

  • Thread starter Thread starter tcjay
  • Start date Start date
T

tcjay

I am looking for a macro that will sort data in numerical order. Dat
is currently sorted as follows:

D-3
D-30
D-31
D-4
D-40

I would like
D-3
D-4
D-30
D-31
D-40

I am not sure how to go about this.

TIA

To
 
I'd use two adjacent helper columns (insert them if you need to).

then select that column and do data|text to columns.

choose delimited (by dash)

and then sort your range by that second helper column (use general as the format
for that column when you separate it).
 
Back
Top