sorting by number

M

mailman

I have a long list like this it is sorted in the first column A to Z but I want to sort by second column 1 , 2, 3, 4 etc. Help please
 
M

mailman

sorry forgot the list
ANTHONY Merv, Ruth, Sarah, Jaremy 113
A.P.S. SERVICES 516
APOLLO DRILLING 63
APOLLO GOLD CORP 605
ARDIANNA ENTERPRISE 160
ARLA INVESTMENT 38
ARMSTRONG, Pat 10
ARPIN, Isabelle 495
ARPIN, Laurent, Carol, Valerie 458
ARSENAULT CLAIRE 22
ARSENAULT, Jean, Carol, Serge, Zoé 352
 
D

Dave Peterson

Select your whole range first (all the columns that are part of the range).
Data|Sort

Choose the second column as your primary sort key. (make sure you check that
header row according to your data).
 
Top