How do I sort like this?

[Mike Mike]

Arvin (pop. 12,956)
Ashland (pop. 20,793)
Atascadero (pop. 26,411)
Atherton (pop. 7,194)
Atwater (pop. 23,113)
Auburn (pop. 12,462)
August (pop. 7,808)
Avenal (pop. 14,674)

How can I sort on the number so I get:

Atherton (pop. 7,194)
August (pop. 7,808)
Auburn (pop. 12,462)
Arvin (pop. 12,956)
Avenal (pop. 14,674) etc.............

Regards
Mike

 

[Don Guillett]

I think you would need to structure your info into 2 columns
City Population
a 1000
b 1
and sort on column B as the key

 

[RagDyer]

You could try this:

In an adjoining ( "helper" ) column, enter this formula:

=--SUBSTITUTE(MID(A1,FIND(".",A1)+1,25),")","")

And copy down as needed.

Then, select *both* columns, and sort on the "helper" column.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[L. Howard Kittle]

Hi Mike,

I did it by using Data > Text to Column, after removing "(" & " )" using,
Find and Replace with Nothing, and then sorting on the population column.

HTH
Regards,
Howard