new user needs help with programing

F

FireBrick

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...

--


-----------------------------------------------------
Lawyer to witness: Now doctor, isn't it true that when a person dies in his
sleep, he doesn't know about it until the next morning?
-----------------------------------------------------

Bill H. in Chicagoland
webcams at http://76.16.160.118:8080
weather at http://hhweather.webhop.org
web blog at http://vote4billheinzinger.blogsport.com


--


-----------------------------------------------------
Things are more like they are now than they ever were before.
-----------------------------------------------------

Bill H. in Chicagoland
webcams at http://76.16.160.118:8080
weather at http://hhweather.webhop.org
web blog at http://vote4billheinzinger.blogsport.com
 
J

Jim Jackson

How do I find the "New Users"? I am interested in the answer myself but
cannot find the forum.
 
D

Don Guillett

you are now on
microsoft.public.excel.programming

so

microsoft.public.excel.newusers
 
J

Jim Jackson

Why do we try to make the simple things so difficult? :) I feel like the
fellow who reported on his trip to the doctor, saying "They x-rayed my head
but couldn't find anything."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top