1、数据在A2单元格中，现在要把所有重复的4替换成Q,也就是3Q5Q6Q；在单元格B2中输入公式=SUBSTITUTE(A$2,"4","Q")
2、替换第1个4，结果也就是3Q5464；在B3单元格中输入=SUBSTITUTE(A$2,"4","Q",1)
或者=SUBSTITUTE(A$2,"4","Q",ROW(A1))
3、替换第2个4，结果也就是345Q64；在B4单元格中输入=SUBSTITUTE(A$2,"4","Q",2)
或者=SUBSTITUTE(A$2,"4","Q",ROW(A2))
4、替换第3个4，结果也就是34546Q；在B5单元格中输入=SUBSTITUTE(A$2,"4","Q",3)
或者=SUBSTITUTE(A$2,"4","Q",ROW(A3))