HELP! How to copy cell with leading zeros &/or fixed length ??

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

I need to copy the daa from several cells to one.

I need to maintain specified character length or numbers with leading zeros
in each cell after I combine them into a single cell.

I'm trying to use =C1&C2&C3

Example:

Cell Length Contents
C1 5 00067
C2 3 XY
C3 6 abcde

so I should end up with 00067 XY abcde
after I combine them.

Any help appriceated. thanks.
 
Hi

unfortunately leading zeros that appear due to format / cells / custom
aren't really there ... so if you want all of the numbers in C1 to have 5
digits change your formula to and this will add the zeros in for you


=REPT("0",5-LEN(C1))&C1&" " & C2 & " " & C3

Cheers
JulieD
 
Back
Top