sorting data

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
 
D

Dave Peterson

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).
 
Top