Forum Discussion
Leading and Trailing Zero in Excel
How to Remove Leading and Trailing Zeros in Excel We have a set of product codes like this : 000P2I290002M900 we want to make it like this P2I290002M9 which means removing all leading and trai...
(x,y,z)=> Text.Trim(y, z) shall work, isn't it?
Good point SergeiBaklan + Thanks. Previous post revised