Change Text

[gregork]

In Cell A1 I have two types of text: 5/3 or 15/2
In Cell A2 I want a formula that changes the A1 text to 053 or 152.

Cheers
GK

 

[Max]

Try in A2: =TEXT(SUBSTITUTE(A1,"/",""),"000")

 

[gregork]

Thanks for your solution Max.

regards
GK

Try in A2: =TEXT(SUBSTITUTE(A1,"/",""),"000")

 

[Max]

You're welcome !