Forum Discussion

Wasfiathhar's avatar
Wasfiathhar
Frequent Visitor
4 years ago
Solved

Number formatting with Specific Text Length

Im having set of data with differnt lenght (5/6/7/8/9/10 etc) i would like to bring on common lenght funtion everyting len = 11 charrector by using power Query.      
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Insert a custom column named Update Code and put following formula

    = Text.PadStart(Text.From([Code]),11,"0")
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Insert a custom column named Update Code and put following formula

= Text.PadStart(Text.From([Code]),11,"0")