In this video, I will show you how to add leading zeros in your data. I have three simple solutions for that. One is using the REPT & LEN functions in Excel. Second is the Text.Repeat and Text.Length in Power Query. And the third option is the Text.PadStart in the Power Query.
0:00 Intro & REPT+LEN Solution
1:35 Text.Repeat+Text.Length Solution
3:08 Text.PadStart Solution
4:21 Final checking & outro
Watch the whole video for further explanation of the process!
Visit my channel: [ Ссылка ]
Link to download the sample file:
[ Ссылка ]
Link on Playlist: Learn Spreadsheet Power Query: [ Ссылка ]
Thanks for your time and I hope you learn something from it.
Help me to reach my target audience by sharing my videos with the right people.
Don’t forget to SUBSCRIBE!
![](https://s2.save4k.ru/pic/BFpQNHEgtMs/maxresdefault.jpg)