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

[µo°Ý] [¤w¸Ñ¨M]excel¦r¦êªº«O¯d

[µo°Ý] [¤w¸Ñ¨M]excel¦r¦êªº«O¯d

¥»©«³Ì«á¥Ñ owen9399 ©ó 2012-2-10 08:45 ½s¿è

¦a§}:
¹ü¤Æ¿¤©M¬üÂí¤¤³ò¨½¢±¢·¾F¹ü·s¸ô¤T¬q¢µ¢²*«Ñ¢¶¢¯§Ë**¸¹¡@¡@¡@


¦p¦ó¥Î¦r¦ê ¦Û°Ê­×§ï¦¨

¹ü¤Æ¿¤©M¬üÂí¤¤³ò¨½¹ü·s¸ô¤T¬q¢µ¢²*«Ñ¢¶¢¯§Ë**¸¹

Range("E2:E65536").Replace What:="¹ü¤Æ¿¤©M¬üÂí*¾F", Replacement:="¹ü¤Æ¿¤©M¬üÂí", LookAt:=xlPart
¥i¬O@  ¤¤³ò¨½  ´N¤£¨£¤F   ,¦p¦ó°µ?
owen

ÁÂÁ¤j¤j´£¨Ñ  
Æg°Õ
owen

TOP

¦^´_ 1# owen9399

Range("F2").Replace What:="¨½*¾F", Replacement:="¨½", LookAt:=xlPart

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD