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 dont have to cut and paste each individual record?
Thanks for your help.

How do I separate data in address field?
 

Look at datatext to columns


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Baylynx" wrote in message
...
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.

How do I separate data in address field?
 

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

"Peo Sjoblom" wrote:

Look at datatext to columns


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Baylynx" wrote in message
...
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.