How do I convert zip+4 to 5-digit zip?
 

I have a spreadsheet with a column that has a mixture of zip+4 and five-digit
zip. How do I quickly make the entire column just five-digit zip?

How do I convert zip+4 to 5-digit zip?
 

=Left(A1,5)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"mniquette" wrote:

I have a spreadsheet with a column that has a mixture of zip+4 and five-digit
zip. How do I quickly make the entire column just five-digit zip?

How do I convert zip+4 to 5-digit zip?
 

=LEFT(A1,5) and fill down as necessary.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"mniquette" wrote:

I have a spreadsheet with a column that has a mixture of zip+4 and five-digit
zip. How do I quickly make the entire column just five-digit zip?