Forum Discussion
SamuelKerns
Oct 06, 2023Copper Contributor
Excell
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?
Thanks
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.