ªð¦^¦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

¦^´_ 1# owen9399

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD