Replace First Zero with Hyphen, But Not Second Zero

[hellyars]

I have a 5 digit alpha numerica ID.  

I want to replace the first instance of "0" with "-", but keep any second instance of "0" if it exists.  

The first instance of "0" will always be in the 2nd or 3rd position.  

If a second "0" exists, it will always be in the 4th position.  

START	DESIRED_OUTCOME
XT01A	XT-1A
D010L	D-10L

[Luke_C · Accepted solution]

@hellyars 

I think you can use the 'replacefirst' function for this. 

[hellyars]

@Luke_C  I did not know that function existed.  Thanks.

[Emil_Kos]

Hi @Luke_C 

This is cool I wasn't aware that there is a formula like this 😀

Thank you for sharing!