SOLVED

Mantener 0 a la izquierda al concatenar

%3CLINGO-SUB%20id%3D%22lingo-sub-2707559%22%20slang%3D%22es-ES%22%3EKeep%200%20left%20when%20concatenating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2707559%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%20custom%20formatted%20column%20to%20add%200%20on%20the%20left%20(Ex%3A%200001)%20and%20when%20concatenating%20in%20the%20final%20column%20the%20zeros%20on%20the%20left%20do%20not%20appear.%3C%2FP%3E%3CP%3EChanging%20the%20original%20column%20to%20text%20format%20achieves%20this%20but%20would%20like%20it%20to%20be%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2707559%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2707622%22%20slang%3D%22en-US%22%3ERe%3A%20Mantener%200%20a%20la%20izquierda%20al%20concatenar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2707622%22%20slang%3D%22en-US%22%3E%3DTEXT(CellWithNumber%2C%22000%23%22)%26amp%3BCellToBeConcatenate%3C%2FLINGO-BODY%3E
Occasional Visitor

Tengo un columna con formato personalizado para agregar 0 a la izquierda (Ej: 0001) y al  concatenar en la columna final no aparecen los ceros a la izquierda.

Al cambiar la columna original a formato texto se logra esto pero quisiera que se

1 Reply
best response confirmed by Marcos50 (Occasional Visitor)
Solution
=TEXT(CellWithNumber,"000#")&CellToBeConcatenate