Select a cell which you will place the result and type this formula=SUBSTITUTE(A1, "1", "2", 1), then the first occurrence of number 1 has been replace with ...
確定! 回上一頁