Change Text

gregork · Feb 25, 2005

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 · Feb 25, 2005

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

gregork · Feb 25, 2005

Thanks for your solution Max.

regards
GK

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

Max · Feb 25, 2005

You're welcome !