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

[µo°Ý] ¦p¦ó§R°£Àx¦s®æ¤¤ªºÁôÂòŸ¹

[µo°Ý] ¦p¦ó§R°£Àx¦s®æ¤¤ªºÁôÂòŸ¹

¦U¦ì¤j¤j¦n
§Ú¦³¤@­Óexcel°ÝÃD§Úªº¤å¥ó¤¤Àx¦s®æ­È
  ActiveCell.FormulaR1C1 = "?COMBINATION WRENCH 7MM?"
§Ú­n¦p¦ó¥h°£«e«á"?....?"   §Úªº¼gªk¦p¤U¦ý¬O·|²MªÅ©Ò¦³¸ê®Æ,§Ú¬dªº? =63¤£ª¾¬O§_¥¿½T
Range("a:a").Replace What:=Chr(63), Replacement:=""
lionliu

¦^´_ 1# lionliu


        Columns("A:A").Select
    Selection.Replace What:="?", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

ÁÂÁÂMARK¤j¤j¦^ÂЦý¬O¤£¯à¥Î·|¥þ±þ
§Úªþ¤W½d¨ÒÀÉ DATA.rar (7.55 KB)
lionliu

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD