When you use our Postcard mailing services, you can upload your addresses in a spreadsheet. The upload works best when all the numbers of zip codes are contained within one cell. If the parts of the zip codes are in seperate cells, follow these step to merge the cells into one.
1
Select a cell
Choose the cell where you want to put the first set of combined numbers.
2
Type the combined ZIP code
For example: 90210–6808. Then, press enter.
3
Select Data
In the menu, select the Data option.
4
Select Flash Fill
You’ll find the Flash fill function in the Data Tools group.
Excel automatically combines the rest of the text for you.
If you are using a ZIP+4ZIP code, use the following format: [5-digit ZIP code] - [+4ZIP]. For example: 90210–6808
