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

Posted about 2 years ago by Paola Tomei

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


Login or Sign up to post a comment