Copper Contributor

I have an excel spreadsheet that has 1062: first name,last name, address, city,, state and the postal zip code which includes four numbers at the end of each zip code. I am trying to upload the list to a company to mail out post cards using my list. The format they use will not upload my list with the last four numbers on the zip code. How I delete just the last four numbers from my list?


1 Reply


Let's say the zip codes are in F2 and down.

Insert a new column in column F, so that the zip codes are in G2 and down.

In F2, enter the formula

=LEFT(G2, 5)

Fill down.

Export the data with the new column F instead of the original zip codes in column G.