losing the leading zero when merging zip+4 postal code

G

Guest

In my worksheet I have one column with a 5-digit zip code and another column
with the zip+4 code in the format -1234. I use CONCATENATE to join them
together, which works expect in the case of a zip code with a leading zero,
as in 01002-1234. The result comes out as 1002-1234. How can I merge the
cells together without losing the leading zero?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to merge Excel address columns when some zips begin with zeros 4
mail merge in excel/losing leading zero 1
leading zero not displaying 1
Zip Codes Dropping Leading Zero 3
Zip code loses leading zero Mail Merge from Excel to Word Labels 1
mixing zip with zip+4 and then sorting 2
Removing the +4 from zip+4 4
zip code and +4 duplicates 3

Top