losing the leading zero when merging zip+4 postal code

E

EMayor

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
Zip Codes Dropping Leading Zero 3
mixing zip with zip+4 and then sorting 2
Leading 0 in Mail Merge document 5
Function to Count Zip Code Digits With Leading Zero 2
Leading zero from Zip Code not print on Label Merge 6
Leading zero lost when saving .csv file 1

Top