ªð¦^¦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 : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD