I have over 1,000 address records in a workbook and the street address column
contains the house number and the street name. I want to create a separate
column for the house number so that I can sort the data by street name. Are
there any shortcuts to doing this without cutting and pasting all the numbers
into a new column?

Select the entire column and use "Text to Column" command under Data menu.
To learn more about how to use this command, see the link below:

http://www.microsoft.com/technet/scr.../tips0503.mspx

Let us know!

"Baylynx" wrote:

I have over 1,000 address records in a workbook and the street address column
contains the house number and the street name. I want to create a separate
column for the house number so that I can sort the data by street name. Are
there any shortcuts to doing this without cutting and pasting all the numbers
into a new column?