I am trying to combine values from many cells into one, but the values have
zero places that get lost after combining them. For example, I need to
combine "00"&"00"&"01" so that the new value reads 000001. But when I do this
with the concatenate function, I lose the 1st zero in every cell so that it
reads 001.
Can anyone help?
Thanks!
-Kier