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

[¤À¨É] ¥Î°}¦C°µ¦r¦ê¤À³Î

[¤À¨É] ¥Î°}¦C°µ¦r¦ê¤À³Î

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2010-8-4 11:00): ¥Î¸ê®Æ­åªR§Y¥i§¹¦¨,½Ðµo¦Ü¤@¯ë°Ï ­Y¬O¤À¨É§@«~½Ð©ñ¤J§¹¾ã¾Þ§@©Î±zªº§@ªk

¥»©«³Ì«á¥Ñ ivanyung ©ó 2010-8-6 13:50 ½s¿è


¾Þ§@¤èªk, ¦b B1 ³]©w·Q­n¨ú¥X¦r¦êªº¦ì¸m, ¤½¦¡«K·|¦Û°Ê¨ú¥X¬Û¹ïªº¦r¦ê, ¥t¥~¤½¦¡¤wÂê©w¤F row 1, ¥i½Æ»s¦Ü¨ä¥L cell ¨Ï¥Î.
xlssplit.zip (8.57 KB)

¦]¥Î¤á²Õ«á¤~¯à¤U¸ü¥»ªþ¥ó
=MID(C76,3,20)

c76=¤À³Î¦ì¸m
3 =²Ä´X½X¶}©lÅã¥Ü
20=¥iÅã¥Üªº´X½X
§Úªº¥\¤O¤~³o»ò¤@ÂI
§Æ±æ¹ï§A¦³©ÒÀ°§U
danny

TOP

¬Ýªþ¥ó.
ivanyung µoªí©ó 2010-8-3 13:59



    ¾Þ§@¤èªk, ¦b B1 ³]©w·Q­n¨ú¥X¦r¦êªº¦ì¸m, ¤½¦¡«K·|¦Û°Ê¨ú¥X¬Û¹ïªº¦r¦ê, ¥t¥~¤½¦¡¤wÂê©w¤F row 1, ¥i½Æ»s¦Ü¨ä¥L cell ¨Ï¥Î.

TOP

¦^´_ 2# danny001

a2 ¦r¦ê
b1 ³]©w»Ý­n¨ú¥X¦r¦êªº¦ì¸m
b2 °}¦C¤½¦¡
  1.     =MID(" " & $A2 & " ",SMALL(IF(MID(" " & $A2 & " ",COLUMN($1:$1),1)=" ",COLUMN($1:$1)),B$1)+1,SMALL(IF(MID(" " & $A2 & " ",COLUMN($1:$1),1)=" ",COLUMN($1:$1)),B$1+1)-SMALL(IF(MID(" " & $A2 & " ",COLUMN($1:$1),1)=" ",COLUMN($1:$1)),B$1)-1)
½Æ»s¥N½X

TOP

11.JPG

=MID(A2,B1,C1)
danny

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD