Excel spreadsheet creation

I have a spreadsheet that I am working with that has a lot of information already entered.  I want to creat a new column that has the "house Number" only in this new column, and it is adjacent to the...