請問若A1~A1000的儲存格值都是00xyzwh(xyzwh為16進位數字)，想在B1~B1000儲存格顯現01xyzwh，若用Excel VBA應如何修改才好 感謝各位?
回答 (2)
2016-09-24 6:49 am
✔ 最佳答案
Sub my_convert()U = [A65536].End(xlUp).Row
For i = 1 To U
Cells(i, 2) = "01" & Right(Cells(i, 1), 5)
Next
End Sub
2016-10-13 9:07 am
網上查
收錄日期: 2021-05-02 14:11:10
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160923064221AABFTWr