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

[µo°Ý] ½Ð°Ý¦p¦ó±N¼Æ¦rªº¦U­Ó¦ì¼Æ¥Î¨ç¼Æ¨ú¥X

[µo°Ý] ½Ð°Ý¦p¦ó±N¼Æ¦rªº¦U­Ó¦ì¼Æ¥Î¨ç¼Æ¨ú¥X

¦U¦ì¦Ñ®v±z¦n¡A¦³¤@­Ó°ÝÃD¤@ª½¤£ª¾¹D¸Ó¦p¦ó¸Ñ¨M¡C§Ú³Ìªñ¦³¤@­Óªí®æ»Ý­n±N¤@­Ó¼Æ­Èªº¦U­Ó¦ì¼Æ©ñ¨ì¤£¦PªºÀx¦s®æ¡Aª½±µ¿é¤J¯uªº«Ü¨S¦³®Ä²v¡A³Â·Ð¦U¦ì!ÁÂÁ¡C

test.rar (1.31 KB)

=IF(LEN($A2)<5-COLUMN(A1),"",--LEFT(RIGHT($A2,5-COLUMN(A1)),1))

TOP

C2=MOD(INT($A2/10^(4-COLUMN(A1))),10)
¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=IF(LEN($A2)
ANGELA µoªí©ó 2011-4-20 16:50



   ÁÂÁ ANGELA ¤jªº¦^µª¡A«Ü§Öªº¸Ñ¨M§Úªº°ÝÃD¡A¦ý§Úµo²{¦pªG¬O¤­¦ì¼Æ¦n¹³´N¤£¦æ¡A¦]¬°µ¹ªº¼Æ¤£¤@©w¬O¥|¦ì¼Æ¡K¡K¦ýÁÙ¬O«ÜÁÂÁ¡C

TOP

C2=MOD(INT($A2/10^(4-COLUMN(A1))),10)
¦V¥k½Æ»s
Hsieh µoªí©ó 2011-4-20 18:33



    ÁÂÁÂHsieh ¤j¤jªº¦^µª¡A±o¨ì¸Ñµª¡A¦ý¦]¬°§Úªº¼Æ¦r¤£½T©w¬O¥|¦ì¼Æ¡A¥i¬O¤w¸g¦¬Ã¬«Ü¦h¤F¡AÁÂÁ¡C

TOP

¦^´_ 5# post640421


    =MOD(INT($A$1/10^(LEN($A$1)-COLUMN(A1))),10)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  post640421


    =MOD(INT($A$1/10^(LEN($A$1)-COLUMN(A1))),10)
Hsieh µoªí©ó 2011-4-20 20:03



    ÁÂÁÂHsieh ¤j¡A±z¯u¬O¤Ó¼F®`¤F¡A¦Û¤v¤]­n¦h§V¤O¤F¡AÁÂÁ¡C

TOP

¦^´_ 4# post640421


    ¤½¦¡­n¬¡¥Î´N¥ý­n¤F¸Ñ¤½¦¡ªº¹B§@­ì²z,¦P¤@­Ó¤½¦¡§â5§ï¦¨§A³Ì¤jªº¦ì¼Æ+1,¨º©È¥¦10¦ì8¦ìªº.

TOP

¦^´_  post640421


    ¤½¦¡­n¬¡¥Î´N¥ý­n¤F¸Ñ¤½¦¡ªº¹B§@­ì²z,¦P¤@­Ó¤½¦¡§â5§ï¦¨§A³Ì¤jªº¦ì¼Æ+1,¨º©È¥¦ ...
ANGELA µoªí©ó 2011-4-20 22:51



    ÁÂÁÂANGELA ªº´£¿ô¡A§Ú¤F¸Ñ¤Fºç¤¤¶ø§®¡A¦Û¤w¦n¹³¤]¯à¬Ý¦¨¥\¨ä¥¦ªº¼Æ­È¤F¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD