ªð¦^¦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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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 : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD