sorting column data
 

I hava column with value e.g.

abc123
def456
ghj789

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

sorting column data
 

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

"Matt T" wrote:

I hava column with value e.g.

abc123
def456
ghj789

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

sorting column data
 

A helper column with just the numbers?
--
Don Guillett
SalesAid Software

"Matt T" wrote in message
...
I hava column with value e.g.

abc123
def456
ghj789

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