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

[µo°Ý] ¦p¦ó©î¶} " ³o­Ó²Å¸¹?

[µo°Ý] ¦p¦ó©î¶} " ³o­Ó²Å¸¹?

¤@¯ë¨Ó»¡§Ú­Ì±`¥Î"a" ¥H¥Nªí¤å¦r,¦Ó¤£¬OÅܼÆ
¦ý¦³¤@­Ó¦r¦ê°²³]¬O(1234ABC"AAA),§Ú­n¥ÎSPLITªº¤è¦¡©î¶} " ³o­Ó²Å¸¹¨ú±o«á­±ªºAAA
«oµLªk°õ¦æ...­WµL¤èªkªü= =

¦³¤j¤jª¾¹D¶Ü? §ÚµLªk¥ÎAR=SPLIT(STR,""") ¨Ó°õ¦æ
PKKO

«á­±¬O¤£¬O³£¥u¦³3­Ó¦r©O¡H¦pªG¬O¥i¥Hª½±µ¨ú«á­±3­Ó¦r¥X¨Ó°Ú¡I

Range("B1").Value = Right(Range("A1").Value, 3)

TOP

¦^´_ 1# PKKO
AR=SPLIT(STR,"""")
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 3# stillfish00


    stillfish00¤j¤j±z¦n¡A±z¯u¬O§Úªº¶Q¤H¡A¤@ª½¥H¨ÓÀ°§U§Ú³\¦h¡A¦¹¦¸°ÝÃD¤]§¹¬ü¸Ñ¨M¤F¡A§Ú¨S¦³·Q¨ì©~µM¥|­Ó"¡A·|¬O¥Nªí¤@­Ó¤å¦r " ªº·N«ä
¹êÅ禨¥\,·P¿E¦Ü·¥!
PKKO

TOP

¦^´_ 2# kuhsuanchieh


    ±z¦n,§Úªº¤å¦r¦ê¦³¤C¤d¦h­Ó¦r,µLªk¥Î³oºØ¤è¦¡,¦]¬°ÁÙ¦³´«¦æªºÃö«Ychr(10),¦Ó¥B¤]¤£ª¾¹D¦o¥X²{ªº¦ì¸m,§Ú¥Î©î¶}ªº¤è¦¡¤w¸g¥i¥H§ä¨ì§Ú­nªº¦r¦ê,ÁÂÁ±z!
PKKO

TOP

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