Alphabetize a list of addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Excell worksheet with street addresses and I want to alphabetize it. The problem is when I try to sort it the system does it by the street address not the name. When the spreadsheet was set up the address cell has both the street number and name
 
Hi Doug
could you please post some example data (plain text - no attachment) as
I'm not so sure what really is in one of your cells (address, name,
number?)
 
I think this will work, There are more cells but this it the cell I am working on

Cell
Addres

745 W. Lacled
1507 Victo
139 Kenmor
346 Mistleto
446 Clearmoun
1113 Keog
66 Tod Lan
66 New Yor

Thanks
dou



----- Frank Kabel wrote: ----

Hi Dou
could you please post some example data (plain text - no attachment) a
I'm not so sure what really is in one of your cells (address, name
number?

-
Regard
Frank Kabe
Frankfurt, German


Doug wrote
 
Hi
try using a helper column with the following formula
=MID(A1,FIND(" ",A1)+1,1024)
and copy down for all rows
 
Sorry I am not an excell expert so I will need to as some basic questions.
what or how do I form a helper column? Do I type the formula at the bottom of the cell?

----- Frank Kabel wrote: -----

Hi
try using a helper column with the following formula
=MID(A1,FIND(" ",A1)+1,1024)
and copy down for all rows
 
Hi Doug
lets say you have your existing data in column A then insert the
formula in cell B1 and copy this cell for all rows (or simply drag this
cell down for all rows). This column B is now your 'helper' column.
For your sorting use this column as it should have skipped the leading
number.

You may use the formula (slightly changed):
=TRIM(MID(A1,FIND(" ",A1)+1,1024))
 
Back
Top