excel - 删除 Excel 中的特定内容

Question

我有一个如下所示的数据格式列表。

???m,"N0000001","????(M)","201405","201405","0.57674","0.60831"

???{???Y,"N0000003","????(M)","201402","201402","0.78170","0.68470"

?}???n?j?`??,"N0000004","????(M)","201407","201407","1.54956","1.54956"

???????Y,"N0000015","????(M)","201412","201412","0.95776","0.98891"

我想删除“N000000”这些部分。只留下有效号码。输出应该是这样的

???m,"1","????(M)","201405","201405","0.57674","0.60831"

???{???Y,"3","????(M)","201402","201402","0.78170","0.68470"

?}???n?j?`??,"4","????(M)","201407","201407","1.54956","1.54956"

???????Y,"15","????(M)","201412","201412","0.95776","0.98891"

有谁知道我应该做什么样的手术？

标签： excelvba

Answer 1

尝试这个。

Sub test()
    Dim rngDB As Range
    Dim Ws As Worksheet
    Set Ws = ActiveSheet
    Set rngDB = Ws.UsedRange
    rngDB.Replace "N000000", ""

End Sub