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

¦p¦ó§R°£¬Ý¤£¨£ªºªÅ¥Õ

ÀɮרS°ÝÃD°Ú
¦pªG©Ò¦³¤èªk³£¤£°_§@¥Î,¨º´N¥Îmid¨ç¼Æ³B²z
¦³¼Æ¦rªºÄæ¥Î
=--MID(D2,2,LEN(D2)-2)

TOP

ÀɮרS°ÝÃD°Ú
¦pªG©Ò¦³¤èªk³£¤£°_§@¥Î,¨º´N¥Îmid¨ç¼Æ³B²z
¦³¼Æ¦rªºÄæ¥Î
=--MID(D2,2,LEN(D2)-2)
ANGELA µoªí©ó 2011-3-8 16:00



    ÁÂÁ±z¡I³o­Ó¤èªkªGµM¬O¦³®Äªº¡A¯uªº¬OÁÂÁ±zÀ°§Ú¸Ñ¨M§ÚªººÃ´b¡A¥u¬O¸£µ¬¤w¸gÂà¶i¦º­J¦P¸ÌµLªkÂà¥X¨Ó¤F¡I
´«¨¥¤§¡A¥L­ì¨Ó®æ¦¡¥þ³¡¬°¤å¦r®æ¦¡¡AÂ^¨ú¥X©Ò­n¤å¦rÂà¶K´NÅܦ¨¼Æ¦r¤F(¥hÀY§À)¡A¯u¬O¤@»yÅå¿ô¹Ú¤¤¤H¡I
¦A¦¸ÁÂÁ¦U¦ìÀ°¦£¡I

TOP

¦^´_ 14# 97forum
³o¤èªkªº«e´£¬O­nª¾¹D«eºó¦r¤¸¦³´X­Ó?
·í«e«á³£¦³¤£¥i¨£¦r¤¸®É¤@¼ËµLªkÂন¼Æ­È
®Ú¥»¤§¹DÁÙ¬OÀ³¸Ó±N¨ä¥h°£
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§ä¤@­ÓªÅ®æ L1¿é¤J
=left(b2)
¦ACOPY  L1 ¨ì´M§ä¥Ø¼ÐÀ³¸Ó´N¥i¥H¤F.

TOP

­n¥Î¼Ð·ÇÁä½L¿é¤J
NB¥i¯àµLªk¨Ï¥Î
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

§ä¤@­ÓªÅ®æ L1¿é¤J
=left(b2)
¦ACOPY  L1 ¨ì´M§ä¥Ø¼ÐÀ³¸Ó´N¥i¥H¤F.
ANGELA µoªí©ó 2011-3-8 23:33



    ³o­Ó¤èªk¸Õ¹L¥i¦æ¡A·PÁ´£¨Ñ¡I

TOP

½Ð°ÝALT + 160 ¬O§_¥u°w¹ï®à¤W«¬¹q¸£·f°t¿W¥ß¦¡Áä½L¤~¦³®Ä? µ§¹q¸Õ¹L¬O¤£¦æªº, ¬O§_¥u¯à±Ä¨ú = SUBSTITUE(Àx¦s®æ," ", "")?  µ§¹q¨Ï¥ÎSUBSTITUE ¬Ookayªº.

TOP

³o©Û¤£¿ù¡C
­ì¨Ó§Ú¤]¬O¥Î Left ¨ú¥X³Ì«á¤@­Ó¦r¤¸«á¡A¦A°µ¨ú¥Nªº¡C
¥ÎAlt- §ó°ª©Û¡C

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD