learning on the fly here
that worked, thank you guys.

sorry I didn't know how to post the question properly.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
If your data is as simple as the example, you could use DataText to
Columns to
split the number away from the street name.

But I'll bet it is more complicated than you show.

Post a real example if of the more complicated type.


Gord Dibben MS Excel MVP

On Mon, 5 Mar 2007 11:25:05 -0600, "FireBrick"
wrote:

it's a spreadsheet of names and addresses
the addresses column has both the street number and address.
like 1233 LAKE ST

What I would like to do, is sort them on the street name AND THEN the
number
so I would have the sheet list them in order of street name and then order
of number
such as
1233 Lake St
1234 Lake St
1235 Lake St
etc.

so how do I split the columns automatically so that it will sort by the
name
alphabetically and then the number numerically

please and thank you...