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

[µo°Ý] ¦p¦óÅã¥Ü¤@¦C¼Æ¦r¤¤¯S©wªº¬Y´X­Ó¡H

[µo°Ý] ¦p¦óÅã¥Ü¤@¦C¼Æ¦r¤¤¯S©wªº¬Y´X­Ó¡H

¤p§Ì¦³¤@­Ó¤p°ÝÃD¡G
¦bA1¿é¤J810205¡A·Q¦bB1¦Û°ÊÅã¥Ü³Ì«e­±ªº¨â­Ó¼Æ¦r¡A¥i¥H¿é¤J =left(A1,2)
¥i¬O¦pªG·Q­nÅã¥Üªº¬O²Ä¤T©M²Ä¥|­Ó¼Æ¦r¡A§Y02¡A½Ð°Ý¸Ó«ç»ò¼g¡H

ÁÂÁÂ~~~~©ú¥Õ¤F~~~~~

TOP

B1=MID(A1,3,2)

TOP

=MID(A1,3,2)
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD