sorting column data

M

Matt T

I hava column with value e.g.

abc123
def456
ghj789

I would like to sort this column on the numbers, is this possible?
 
M

Mike H

Assuming you data are in A1 - A1000 use a helper cell. In b1 type

=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$1000),1)),0),999)

Note it's an array so CTRL+Shift+ Enter and then drag down
This will extract the numeric part from the end of each cell
Select the 2 columns and sort on column B.
Delete or hide colimn B

Mike
 
Top