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.

PN #	Length	Feet	Other Parts
C1-LCLCBD3OM2APLDC3M <tbody> </tbody>	003	M	C1-LCLCBD3OM2APLDC
C1-LCLCBD3OM2APLDC270F <tbody> </tbody>	270	F	C1-LCLCBD3OM2APLDC <tbody> </tbody>

<tbody>
</tbody>

 

[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)