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

½Ð°Ý¦p¦ó±N Excel ¤¤ªº³sÄò¼Æ¦r¤À¶}.

½Ð°Ý¦p¦ó±N Excel ¤¤ªº³sÄò¼Æ¦r¤À¶}.

½Ð°Ý¦p¦ó±N Excel ¤¤ªº³sÄò¼Æ¦r¤À¶}

¨Ò¦p¡GA1 Àx¦s®æ¤¤¼Æ­È¬°¡u0011 ¡v

¦bExcel ¸Ì­n«ç¼Ë¼g¨ç¼Æ  ¤~¯à¦Û°Ê±N³sÄò¼Æ¦r¤À¶}¨Ó

ÁÂÁ ·P®¦¡I

¦^´_ 1# la1975

Àx¦s®æ¤º§¹¥þ³£¬O¼Æ¦r¶Ü¡H
­Y¬O¦p¦¹¥i§Q¥Î¸ê®Æ­åªR
­Y¤£¬O¡A½Ð¤W¶ÇÀɮסA¥H«K¾é¸Ñ¸ê®Æ¯S©Ê¡A§Q¥Î¨ç¼Æ¨ú¥X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥Î¨ç¼ÆMID(A1.1.1)¥i±o²Ä¤@­Ó¼Æ¦r0
¥Î¨ç¼ÆMID(A1.2.1)¥i±o²Ä¤G­Ó¼Æ¦r0
¥Î¨ç¼ÆMID(A1.3.1)¥i±o²Ä¤T­Ó¼Æ¦r1
¥Î¨ç¼ÆMID(A1.4.1)¥i±o²Ä¥|­Ó¼Æ¦r1

TOP

B1 =MID($A1,COLUMN(A1),1)
¥k©Ô3®æ½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


   ÁÂÁ ML089  ´ú¸ÕOK  ·P®¦¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD