I have data with variable length and variable number of leading zeros. I'm trying any type of concatenation or formula to keep the zeros. The cells are formated as custom ########0. Values look like this:
aaa 123456
bbb 005005
ccc 043434
ddd 000505
I want to concatenate and get exactly the values without dropping or adding zeros like 'ddd 000505' or 'aaa 123456'
I've tried format cells to text and it drops the zeros. I've tried = "'" & A1.
Everything I try drops the zeros or adds one zero when none are there.
Any ideas?
Thanks,
Frank
aaa 123456
bbb 005005
ccc 043434
ddd 000505
I want to concatenate and get exactly the values without dropping or adding zeros like 'ddd 000505' or 'aaa 123456'
I've tried format cells to text and it drops the zeros. I've tried = "'" & A1.
Everything I try drops the zeros or adds one zero when none are there.
Any ideas?
Thanks,
Frank