如何删除单元格A1中的所有“*”号,可以使用下列()公式完成。
A: =SUBSTITUTE(A1,"*","",1)
B: =SUBSTITUTE(A1,"*","",0)
C: =SUBSTITUTE(A1,"*","*")
D: =SUBSTITUTE(A1,"*","")
A: =SUBSTITUTE(A1,"*","",1)
B: =SUBSTITUTE(A1,"*","",0)
C: =SUBSTITUTE(A1,"*","*")
D: =SUBSTITUTE(A1,"*","")
