I have a long list of addresses that for some reason have the street portion of the address in one cell and the city, state, zip code in the next cell. Is there someway to tell excel to copy the text in the second cells and insert it in the first cell? Or to combine the info in the two adjacent cells?
Bookmarks