sorting columns in OpenOffice Calc

Associate
Joined
13 Aug 2005
Posts
168
what i am trying to do is to sort them into alphabetical order by the street name, problem is, the numbers before the street and i cant find out how to do it

i'd like this:

120 Moss Side terrace
123 BLAMEY AVENUE
14 HILLVIEW CRESCENT
142 Stenhouse Place

to become this:

123 BLAMEY AVENUE
14 HILLVIEW CRESCENT
120 Moss Side terrace
142 Stenhouse Place

any ideas?
 
Back
Top Bottom