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

Ãö©óÅý­^¼Æ¦r²V¦X½s¸¹,¦p¦ó¨Ì§Ç±Æ§Ç

Ãö©óÅý­^¼Æ¦r²V¦X½s¸¹,¦p¦ó¨Ì§Ç±Æ§Ç

Ãö©óÅý­^¼Æ¦r²V¦X½s¸¹,¨Ì§Ç±Æ§Ç
¦p
9A1B~9A20B

±Æ§Ç§¹·|Åܦ¨
9A1B
9A10B
9A11
9A12

¶¶§Ç³£¤£¹ï¤F,ª¾¹D¥i¥Î¦Û­q±Æ§Ç¦ý¬O§Úªº­^¤å¥N¸¹¤£¬O©T©w¦P¤@­Ó...

¥H³o¤½¦¡¬°»²§UÄæ±Æ§Ç, ¥ý¸Õ¸Õ:
=REPLACE(IF(COUNT(-LEFT(A1&1,2)),,0)&A1,4,0,IF(COUNT(-MID(A1&"a11",{3,4},2)),,0))

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-9-29 14:36 ½s¿è

¦^´_ 2# ­ã´£³¡ªL

·PÁª©¤j~¸É¹s¤W¥h«á¥i¹F¦¨¥Ø¼Ð,

¥t·Q¨ì¥t¤@­Ó¸Ñ¨M¤èªk,±N­ì¥»¦Û°Ê²£¥Íªº½s¸¹¸É¦¨¨â¦ì,¨Ã¥ÎtextÂà´«¬°¤å¦r¨Ó¹F¦¨¦P¼Ë®ÄªG

TOP

¦^´_ 3# starry1314


¹ï¦³¸gÅ窺³]­pªÌ¦Ó¨¥, ¤ë½X¤Î¤é½X·|±Ä¥Î mm  dd  ©T©w¬°¢±¦ì¼Æ¡A¨Ï½s½X§e¤@­Pªº¬Ûµ¥¦r¤¸¼Æ¡A
¤£­n¨Æ«á¦A¤`¦Ï¸É¨c¡A¥[®Æ¤S¥[´ö¡ã¡ã

TOP

¦^´_ 4# ­ã´£³¡ªL

®¦®¦~¤F¸Ñ¡I
¯uªº¨S¤°»ò¸gÅç¡A­ì¥»µ¹ªº¸ê®Æ¬O¦p¦ó´Nª½±µ¨Ì¼Ë°µ¤U¥h
¨S·Q¨ì¤@­P©Êµ¥¡ã±`¦b¨Æ«á­×¥¿¬°²Î¤@³W®æ

TOP

http://blog.xuite.net/hcm19522/twblog/346429031

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD