ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] SUBSTITUTE-VBA¨Ï¥Î¤è¦¡½Ð±Ð

«ØÄ³¤W¶ÇÀÉ®×~~

TOP

Dim xR As Range
Application.ScreenUpdating = False
For Each xR In Range([A2], [A65536].End(3))
    If xR = "T45" Then Range(xR(1, 2), xR(1, 4)).Replace "¦¨«¬", "Äé¤Õ", Lookat:=xlPart
Next

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD