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

¤£¥Î°j°é¡A¤£¥ÎWorksheet¨ç¼Æ¡]matchµ¥¡^¡A§PÂ_¬Yelement¦b¬O§_°}¦C¤¤

¦^´_ 8# sunnyso

ÁöµM³o­Ó°Q½×¦ê¾ú¥v¤w¤[¡A(4¦~«e...
¦ý¤´µM¹ï§Ú¦³«Ü¤jªºÀ°§U¡A
ÁÂÁ¦U¦ì¥ý¶iªºÀ°§U¡I

¦ý 05. ¤¤ ¡uAj = S & "DAÃþ" & S¡v¦³ÂI¤pºÃ°Ý¡A
­Y¦¹®É·j´M¹ï¶HÅܦ¨JÃþªº®É­Ô¡A
«K·|µLªk§ä¨ì¡A
­ì¦]¦b©ó¡A
Aj ¸g 05. ³B²z«á¡AÅܦ¨¡u,JÃþ,¡v
¦ý Ar ¦r¦ê¦b 06. ³B²z«á¡AÅܦ¨¡u ,DAÃþ,BÃþ,DECÃþ,ECÃþ,CÃþ,FÃþ,GÃþ,HÃþ,IÃþ,JÃþ¡v
¦¹®É¥ÎInStr(Ar, Aj)¡Aµ´¹ï·|µ¥©ó 0

¸Õ°Ý¡A
05. ¤¤¡A«á­±ªº&S­ì¥»¥ß·N¬°¦ó¡H
¬O¤£¬O§Q¥Î¨â­Ó","¨Ó¨M©w¦r¦êªºÀY»P§À¡H
­Y¬O¦p¦¹¡A¦pªG¦b¡uAr = " " & S & Join(alltype, S)¡v«á­±°l¥[ & S¡A·|§ó§¹¬ü¡H:P

³Ì«á¡AÁÙ¬O·PÁ¦U¦ì¤j¤j¡A
©~µM¥i¥H¬¡¥ÎJoin¦A°t¦XInStr¹F¨ì§P©w¬O§_¦s¦bªº¥Øªº¡A
³Ì«á¦A³sÄò§Q¥ÎSplit¨Ã°t¦XUBound¨Ó«ü¥X¸Ó¶µ¥Øªº¦ì¸m¡A
¹ê¦b¼F®`¡IXD

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD