Thread: How do you alphabetize street addresses within a column?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default How do you alphabetize street addresses within a column?
Hi,

An easy way is to create two new helper columns, one containing the number,
the other containing the street name.
Assuming the numbers and names are in column A,then put

=--LEFT(A1,FIND(" ",A1,1)) in B1 and drag down.

Put

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) in C1 and drag down

Then sort on column C, making sure you expand the range to include column A
and B in the range.

Dave

url:http://www.ureader.com/msg/104236262.aspx
Reply With QuoteReply With Quote