excel同一单元格中有多组文字和数字怎么用宏公式求和答:Sub 计算()Columns("A:A").Select Selection.Replace What:="米", Replacement:="", LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ReplaceFormat:=False Selection.Replace What:="根", Replacement:="", LookAt:=xlPart, _SearchOrder:=xlByRows, ...