software

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 datagt;text to columns--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Baylynxquot; gt; wrote in message
...
gt;I have over 1,000 records in an address data base. The street address
gt;field
gt; contains both the house number and the street name. I need to place these
gt; in
gt; separate fields so that I can sort by street name. Is there a shortcut to
gt; doing this so that I don't have to cut and paste each individual record?
gt; Thanks for your help.
gt;
Wow that makes it so easy! Thank you so much and have a great weekend.

quot;Peo Sjoblomquot; wrote:

gt; Look at datagt;text to columns
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Baylynxquot; gt; wrote in message
gt; ...
gt; gt;I have over 1,000 records in an address data base. The street address
gt; gt;field
gt; gt; contains both the house number and the street name. I need to place these
gt; gt; in
gt; gt; separate fields so that I can sort by street name. Is there a shortcut to
gt; gt; doing this so that I don't have to cut and paste each individual record?
gt; gt; Thanks for your help.
gt; gt;
gt;
gt;
gt;