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, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
For I = 1 To Range("A65536").End(xlUp).Row
Cells(I, "b") = "=" & Cells(I, "a")
Next
End Sub
可以用我的这一组数据为例说一下吗?谢谢!