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

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