Help is here.

My ZIP+4ZIP codes are in separate columns. How do I merge them into 1?

All numbers of a ZIP code must be contained within 1 cell.

If using a ZIP+4ZIP code, use the following format: [5-digit ZIP code] - [+4ZIP]
For example: 90210-6808

  • Click the cell where you want to put the first set of combined numbers.
  • Type the combined zip code (example: 90210-6808).
  • Press ENTER.
  • Click Data.
  • Click Flash Fill from the Data Tools group.
  • Excel automatically combines the remainder of the text for you.