Forum Discussion
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 ...
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.