Remove zeros before 1-9

[Crispy131]

Hello,

I have a column of data that looks like below and I want to remove all the zeros on either side of the dash that are leading zeros. 

01-03

05-10

25-07

16-08

04-14

17-20

Result I expect:

1-3

5-10

25-7

16-8

4-14

17-20

Any help is much appreciated!

[Felipe_Ribeir0 · Accepted solution]

Hi @Crispy131 

One way of doing this

(^0)|(?<=\-)(0)

[Crispy131]

Worked a treat! Thank you

[flying008]

Hi,@Crispy131 

There is a easy way of RegEx expression:

0(?=[1-9])

[Crispy131]

So simple thank you!

[flying008]

Hi,@Crispy131 

If can help you  get your want, please mark it as a solution for share more. 😁