excel中如何替换相同的内容

1、数据在A2单元格中，现在要把所有重复的4替换成Q,也就是3Q5Q6Q；在单元格B2中输入公式=SUBSTITUTE(A$2,"4","Q")

2、替换第1个4，结果也就是3Q54瀵鸦铙邮64；在B3单元格中输入=SUBSTITUTE(A$2,"4","Q",1)或者=SUBSTITUTE(A$2,"4","Q",ROW(A1))

3、替换第2个4，结果也就是345Q瀵鸦铙邮64；在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))