Replace / and bring zero at initial position

[James Clear]

Hi All,

I want to replace last digit and bring Zero at initial position

for example

21-22/RFL/<10K/AS/1 - it should give me 21-22/RFL/<10K/AS/01 similaraly for 21-22/RFL/<10K/AS/10 it should give me 21-22/RFL/<10K/AS/010

 

[Peter_SSs]

If there is always 4 "/"s in the original text like your samples then try ..

22 02 09.xlsm
	A	B
1	21-22/RFL/<10K/AS/1	21-22/RFL/<10K/AS/01
2	21-22/RFL/<10K/AS/10	21-22/RFL/<10K/AS/010
Insert 0

Cell Formulas
Range	Formula
B1:B2	B1	=SUBSTITUTE(A1,"/","/0",4)

If your data is not as uniform as that then please give some samples that show the sort of variety that you actually have as well as the expected results (preferably with XL2BB)

 

[James Clear]

If there is always 4 "/"s in the original text like your samples then try ..

22 02 09.xlsm
	A	B
1	21-22/RFL/<10K/AS/1	21-22/RFL/<10K/AS/01
2	21-22/RFL/<10K/AS/10	21-22/RFL/<10K/AS/010
Insert 0

Cell Formulas
Range	Formula
B1:B2	B1	=SUBSTITUTE(A1,"/","/0",4)

If your data is not as uniform as that then please give some samples that show the sort of variety that you actually have as well as the expected results (preferably with XL2BB)

Thanks Peter ,

I did this long formula

REPLACE(A2,SEARCH("^",SUBSTITUTE(A2,"/","^",4)),1,"/0")

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

Your formula looks fine - but now you have a shorter option.