G
Guest
Hello
This may work, but not entirely sure if it will work in
all conditions. I presume the following set up...
A1 B1
CCC 05555
I assume cell B1 is a 'custom format' so that it displays
the '0' of the 05555. [By the way, if you enter the data
as '05555 then the 0 is preserved, it is treated as text,
and your problem would be easier].
In cell C1 type the following...
=A1&(0&VALUE(B1))
This will give the result CCC05555.
Does this help any...?
This may work, but not entirely sure if it will work in
all conditions. I presume the following set up...
A1 B1
CCC 05555
I assume cell B1 is a 'custom format' so that it displays
the '0' of the 05555. [By the way, if you enter the data
as '05555 then the 0 is preserved, it is treated as text,
and your problem would be easier].
In cell C1 type the following...
=A1&(0&VALUE(B1))
This will give the result CCC05555.
Does this help any...?