I am sorry to be so dumb, but what is parsing? and if I do that will I lose
the house number, or will it be in a different column. I don't want to lose
the house number.

"R. Choate" wrote:

> You need to parse the street number from the street name and then sort them. The quickest way to do this to use DATA>TEXT TO COLUMNS
> from the Excel menu. This will give you the choice of either parsing by fixed number of characters or by some delimiter, like a
> space. When I have done this, I have always encountered people in the list who have an address which begins with a company name or
> "c/o", or something like that.
>
> Another option for you is to write a formula that will search for the first space and return everything after that. You would be in
> a better position to know which would work best for you. If you feel the formula route would help the most but need help writing it,
> let me know and I'll give you an example.
>
> Regardless of which route you go, you can send the results to Access after that if you want. However, Excel can handle this job
> easily and is probably just as easy to deal with capitalization issues and oddball exceptions from the normal record.
> --
> RMC,CPA
>
>
> "justaMom" <justaMom@discussions.microsoft.com> wrote in message news:27C7353B-F247-448E-A062-9C75CFAAC316@microsoft.com...
> I have an Excel spreadsheet that contains 4,000 names and addresses of local
> registered voters. The addresses are listed with the house number and street
> (102 Oak Ave., eg) I want to sort the data so that all the people living on
> the same street are together. Is there any way to do that in Excel, and if
> not, is it possible to export the spreadsheet to Access and do it there. I
> have tried several times to read the spreadsheet in as an Access data base,
> but no luck. But I don't know if it is possible to do that even if I could
> get the data base set up. Anyone got any suggestions?
>
>
>