Concatenating but keeping the leading zeros

[Formulation]

I'm trying to concatenate several columns, one of which contains leading zeros in some of the cells.

Example below: Row two is correct (PN # Column)
Row 1 is not bringing over the "00" in "003"
I have the length column set to display as 003 but concatenate is removing the two 0's.


[TABLE="width: 650"]
<tbody>[TR]
[TD]PN #[/TD]
[TD]Length[/TD]
[TD]Feet[/TD]
[TD]Other Parts[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="width: 215"]C1-LCLCBD3OM2APLDC3M[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]003[/TD]
[TD]M[/TD]
[TD]C1-LCLCBD3OM2APLDC[/TD]
[/TR]
[TR]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="width: 215"]C1-LCLCBD3OM2APLDC270F[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]270[/TD]
[TD]F[/TD]
[TD][TABLE="width: 215"]
<tbody>[TR]
[TD="width: 215"]C1-LCLCBD3OM2APLDC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Kamolga]

If 003 is in cell B2, you can try something like

=CONCATENATE(A2;TEXT(B2;"000"))

 

[Formulation]

If 003 is in cell B2, you can try something like

=CONCATENATE(A2;TEXT(B2;"000"))

Thanks. My original formula is:

=CONCATENATE(F7, "-",K7,M7,AA7,Q7,O7,W7,U7,Y7,I7,H7)

I7 in the formula = 003
Sometimes it may be 012, which is also only displaying as 12 after concatenating.

How would I use your code but include the other cells including the dash(-) after F7?


I've tried a few methods I found on google but they either won't work or are related to adding a static number of 0's as a prefix.

 

[Formulation]

I tried something new and it seems to be working. I suppose I'll use this unless someone has a reason why I shouldn't.

=CONCATENATE(F8, "-",K8,M8,AA8,Q8,O8,W8,U8,Y8,[B]TEXT(I8,"0##")[/B],H8)

It's concatenating 001, 011, and 111 correctly.

 

[Formulation]

Actually ended up using something similar to your formula and it worked. Thanks

=CONCATENATE(F7, "-",K7,M7,AA7,Q7,O7,W7,U7,Y7,TEXT(I7,"000"),H7)