I have a spreadsheet that contains, in part, 5 columns of numbers that I want to combine to create one overall field that can be used as a key field. The number of digits in each column is different but I want a fixed-length digit as the output. There are leading zeros (for example "001) in some fields and others contain all zeros ("00000") but every digit is important as part of the code. How can I combine these fields? I am obviously not an experienced programmer. I have tried the concatenate formula but I lose the placeholder zeros. Thanks for any help you can offer.
Last edited by a moderator: