Trim leading zeros - clean product codes, telephone numbers or reference number fields

Posted over 2 years ago by Paola Tomei

P
Paola Tomei Admin

Here's a handy formula that will trim leading zeros (any number) in data that might contain mix of numbers and text.


MID([Field 1], SEARCHREGEX(`[^0]`, [Field 1]), LEN([Field 1]))


0 Votes


0 Comments

Login or Sign up to post a comment