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

¦p¦óºI¨ú¬Y¤@¦r²´(K2)«_«á¤§«áªº10­Ó¦r

¦p¦óºI¨ú¬Y¤@¦r²´(K2)«_«á¤§«áªº10­Ó¦r

°ÝÃD:
¦p¦óºI¨úk2«_¸¹¥H«áªº¦r¦ê¡A¦@10­Ó¦r(¤£§t«_¸¹)¡Aµª®×¦bBÄæ
k2®æ¦¡¡A­^¤å¦rk¦³¤j¼g©Î¤p¼g¡F¥t¡Ak2«á­±«_¸¹¡A¦³ªº¥þ§Î¦³ªº¥b§Î
°£¤F¥H¤Wªº±¡§Î¥~¡A¦³¥i¯à¦b2«á­±¦³¤@­Ó¡y½X¡z¦r(¨Ò¦pA5~A8)

¦p¦óºI¨ú¬Y¤@¦r²´(K2)«_«á¤§«áªº10­Ó¦r.zip (6.74 KB)

joyce

¦^´_ 1# leiru


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/aaUxUL
E0229_1.png
2018-6-25 13:40

TOP

¦^´_ 1# leiru

¦pªG­n§ìªº¦r¦ê¤@©w¥X²{¦b«_¸¹«á­±

¥i¥H¥Î¤U¤è°µªk¸Õ¬Ý¬Ý
  1. =IF(ISERROR(MID(A1,FIND(":",A1)+1,10)),MID(A1,FIND("¡G",A1)+1,10),MID(A1,FIND(":",A1)+1,10))
½Æ»s¥N½X
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

=MID(A1,FIND(":",SUBSTITUTE(A1,"¡G",":"))+1,10)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÁÂÁ¦U¦ì,¤£¦n·N«ä,¯u¥¿ÃD¥Ø¤@­ÓÀx¦s®æ¤º,¦³¥i¯à¦³¦h­Ó«_¸¹
joyce

TOP

=MID(A1,FIND(":",ASC(A1&":"))+1,10)

TOP

¦^´_ 5# leiru

¦p¦óºI¨ú¬Y¤@¦r²´(K2)«_«á¤§«áªº10­Ó¦r.zip (6.81 KB)

joyce

TOP

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

TOP

¦^´_ 7# leiru


=MID(A1,-LOOKUP(,-SEARCH({"K2:","K2½X:"},ASC(A1))-{3,4}),10)

TOP

=MID(A1,FIND(":",ASC(A1),SEARCH("K2",A1))+1,10)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD