Forum Discussion

Copper Contributor

Nov 20, 2023

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...

Formulas and Functions

office 365

training

peiyezhu

Bronze Contributor

Nov 21, 2023

=WEBSERVICE("http://e.anyoupin.cn/eh3/?regreplace~^0+|0+$~~" & A2)