Combining information from 3 cells into One - Street Address Issue

I get a spreadsheet every day with the number of the address in one column the name of the street in another column and the city in 1/3 column and I'd like to take all of this data and put it into on...