C
coa01gsb
Hello All,
Could do with a hand. I have a formula in a cell that adds the length
of strings in other cells (=LEN(B2)+LEN(B3)+LEN(B4).....). I want to
ensure that this cell is always 6 characters long, padded with zero's
from the left. For example if total length of other cell values is 9 I
want my cell to read 000009, but if it's 999, I want my cell to read
000999.
Hope that's explained well enough, is there a simple solution?
Could do with a hand. I have a formula in a cell that adds the length
of strings in other cells (=LEN(B2)+LEN(B3)+LEN(B4).....). I want to
ensure that this cell is always 6 characters long, padded with zero's
from the left. For example if total length of other cell values is 9 I
want my cell to read 000009, but if it's 999, I want my cell to read
000999.
Hope that's explained well enough, is there a simple solution?