Forum Discussion
dolevh
Helper II
4 years agoDelete numbers
Hi, I want to delete the number '0' before the integers. Thanks!
- Anonymous4 years ago
Hi dolevh ,
Try to add a custom colum in power query
= Text.TrimStart([Column1],"0")Reference: Remove Leading Zeros from Text in Power Query - YouTube
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
4 years agoNot applicable
Hi dolevh ,
Try to add a custom colum in power query
= Text.TrimStart([Column1],"0")
Reference: Remove Leading Zeros from Text in Power Query - YouTube
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.