How do I separate data in address field?

I have over 1,000 records in an address data base. The street address field
contains both the house number and the street name. I need to place these in
separate fields so that I can sort by street name. Is there a shortcut to
doing this so that I don’t have to cut and paste each individual record?
Thanks for your help.

Look at data>text to columns


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Baylynx" <[email protected]> wrote in message
news:[email protected]...
>I have over 1,000 records in an address data base. The street address
>field
> contains both the house number and the street name. I need to place these
> in
> separate fields so that I can sort by street name. Is there a shortcut to
> doing this so that I don't have to cut and paste each individual record?
> Thanks for your help.
>

Wow that makes it so easy! Thank you so much and have a great weekend.

"Peo Sjoblom" wrote:

> Look at data>text to columns
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
>
> "Baylynx" <[email protected]> wrote in message
> news:[email protected]...
> >I have over 1,000 records in an address data base. The street address
> >field
> > contains both the house number and the street name. I need to place these
> > in
> > separate fields so that I can sort by street name. Is there a shortcut to
> > doing this so that I don't have to cut and paste each individual record?
> > Thanks for your help.
> >
>
>
>