Oct 06 2023 01:52 PM
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
Oct 06 2023 02:07 PM
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.