"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chuck

A simple method is to break out the addresses into separate columns then
sort
on the street name column.

Select the column with the address(make sure you have a few empty columns
to
the right of the data column).

DataText to ColumnsDelimited by space and finish.

Select all the columns and sort on street name.

Best to leave them split out that way. Most apps you export to like them
in
separate cells.

You can stick them back into one cell after the sort if you wish.

=A1 & " " and B1 & " " & C1


Gord Dibben Excel MVP



On Mon, 13 Jun 2005 17:07:09 -0700, "Chuck Davis" <newsgroup at anthemwebs
dot
com wrote:

I have an excel worksheet with addresses in the form of "1234 Some St."
I would like to sort by street name.

Any solution?

Thanks in advance


Thanks again. It worked, except I can never delete the columns with the
numeric and alpha data. Its not a real problem.