Concatenate until reaches specific length

Question

Hello,

I have a table, and there is 1 column with variable length. I want to do an if condition: if the length of the values in this column is less than 10, then I want to concatenate 0s to the left of it until it reaches length 10.

For example: 666666 -> 000066666; 12345 -> 0000012345

Can I do this using a formula tool? Any sugestion?

ShankerV · Accepted Answer

Hi @cutehappybear

Please use the function PADLEFT([columnname],10,"0")

Note: The column should be string datatype. To get this formula work.