Concatenate custom cells
 

I've managed to concatenate 4 cells into 1 but they are custom format
(as they need to be a certain length) so many have leading 0's. The
cell displaying the joint information is missing out the 0's. How can I
get the concatenation to show all the numbers?

eg. 06263212103641 + 09940351822154315 + 0000000000461579 =
62632121036419940351822154315461579 but I want
06263212103641099403518221543150000000000461579

Concatenate custom cells
 

Have you tried changing the format for the cells you want to combine to
text first?

Regards
dh01uk


--
dh01uk
------------------------------------------------------------------------
dh01uk's Profile: http://www.excelforum.com/member.php...o&userid=30442
View this thread: http://www.excelforum.com/showthread...hreadid=501035

Concatenate custom cells
 

One way:

=TEXT(A1,"00000000000000") & TEXT(A2, "00000000000000000") &
TEXT(A3, "0000000000000000")

In article .com,
"Lou" wrote:

I've managed to concatenate 4 cells into 1 but they are custom format
(as they need to be a certain length) so many have leading 0's. The
cell displaying the joint information is missing out the 0's. How can I
get the concatenation to show all the numbers?

eg. 06263212103641 + 09940351822154315 + 0000000000461579 =
62632121036419940351822154315461579 but I want
06263212103641099403518221543150000000000461579

Concatenate custom cells
 

When changing the number to text it doesn't retain the correct
number.... changes 06263212103641 to 1.62632E+13

Concatenate custom cells
 

Then you didn't use the TEXT() functions the way I illustrated.

Are you trying to add the strings (i.e., using "+") rather than
concatenate ("&")???

That wouldn't explain your example, 06263212103641, if anything, should
be changed to 6.26321E+12, not 1.62632E+13


In article .com,
"Lou" wrote:

When changing the number to text it doesn't retain the correct
number.... changes 06263212103641 to 1.62632E+13

Concatenate custom cells
 

Worked a treat, thanks very much.