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

¨ú²Ä¤@­Ó©M²Ä¤G­Ó©M²Ä¤T­Ó ¯S®í²Å¸¹¤§«e¦r¦ê

¨ú²Ä¤@­Ó©M²Ä¤G­Ó©M²Ä¤T­Ó ¯S®í²Å¸¹¤§«e¦r¦ê

°ÝÃD¡G
AÄæ¨ú±oDÄæ²Ä¤@­Ó/¤§«e¦r¦ê
BÄæ¨ú±oDÄæ²Ä¤G­Ó/¤§«e¦r¦ê
CÄæ¨ú±oDÄæ²Ä¤T­Ó/¤§«e¦r¦ê

µù:ª¾¹D¥i¨Ï¥Î¸ê®Æ­åªR,·Q»¡¬O§_¥i¥H§Q¥Î¤½¦¡¸Ñµª,ÁÂÁÂ
joyce

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


   ÁÂÁ¦^ÂÐ
¦ýA5Àx¦s®æ¤£­n¦³¸ê®Æ
joyce

TOP

¦p¤U

A2=IF(ISERROR(MID(D2,1,SEARCH("/",D2)-1)),"",MID(D2,1,SEARCH("/",D2)-1))

B2=IF(ISERROR(MID(D2,SEARCH("/",D2)+1,SEARCH("/",D2,SEARCH("/",D2)+1)-SEARCH("/",D2)-1)),"",MID(D2,SEARCH("/",D2)+1,SEARCH("/",D2,SEARCH("/",D2)+1)-SEARCH("/",D2)-1))

C2=IF(ISERROR(MID(D2,SEARCH("/",D2,SEARCH("/",D2)+1)+1,SEARCH("/",D2,SEARCH("/",D2,SEARCH("/",D2)+1)+1)-SEARCH("/",D2,SEARCH("/",D2)+1)-1)),"",MID(D2,SEARCH("/",D2,SEARCH("/",D2)+1)+1,SEARCH("/",D2,SEARCH("/",D2,SEARCH("/",D2)+1)+1)-SEARCH("/",D2,SEARCH("/",D2)+1)-1))
ù

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD