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

ºI¨ú²Å¦X¯S©w¦r¦ê

ºI¨ú²Å¦X¯S©w¦r¦ê

AÄæ¦Û¥kÃäºI¨ú²Å¸¹DÄ檺¦r¦ê¡A©ñ¦bCÄæ¡A¨ä¾lªº©ñ¦bBÄæ

ºI¨ú²Å¦X¯S©w¦r¦ê.zip (47.37 KB)

joyce

¦^´_ 1# leiru
  1. B1 =LEFT(A1,FIND(D1,A1&D1)-1)
  2. C1 =SUBSTITUTE(A1,B1,)
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

­º¥ý¡AÁÂÁ±z¦^ÂСD
µª®×¤£¹ï¡A¤j®vªº¤½¦¡¬O¨C¤@¦C¹ïÀ³DÄæ¡A
§Ú­nAÄæ¥h§ä²Å¦XDÄæ½d³ò¤º±ø¥ó¡AµM«áºI¨ú¡D

§Úªº°ÝÃD¬O:
DÄæ¬O¤@­Ó½d³ò¡A¥u­nAÄ椺±q¥kÃäºâ°_¡A¦³²Å¦XDÄæ½d³ò¤ºªº¸ê®ÆºI¨ú¤U¨Ó©ñ¦bCÄæ¡AAÄ椺¦©°£CÄ檺´N©ñBÄæ

½Æ¥» ºI¨ú²Å¦X¯S©w¦r¦êRE.zip (68.52 KB)

joyce

TOP

¦^´_ 1# leiru

C1=RIGHT($A1,LOOKUP(2,1/(ISNUMBER(MATCH(RIGHT($A1,ROW($1:$255)),$D$1:$D$180,0))),ROW($1:$255)))
B1=SUBSTITUTE($A1,$C1,"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

µª®×¬O³o­Ó
    ÁÂÁÂhsieh
joyce

TOP

¢Ð¢°¡G
=LOOKUP(,0/FIND(D$1:D$200&"|",A1&"|")/(D$1:D$200<>""),D$1:D$200)
­Y¦³¤£²Å¦XªÌ¡A¥~¥[ IFERROR ¥h±Æ¿ù¡ã¡ã

¢Ñ¢°¡G
=LEFT(A1,LEN(A1)-LEN(B1))

ª`·N¡G­Y¦r¦ê¤¤¦³¨â­Ó²Å¦X¦r¬q¥H¤W¡A¨Ï¥Î SUBSTITUTE ®É±N¥þ³Q¨ú¥N
¡@¡@¡@¨Ò¦p¡G9152793258027932580¡@¨ú¥N 27932580 ·|Åܦ¨ 915

TOP

¦^´_ 3# leiru

»~·|·N«ä¤F

B1 =LOOKUP(,-SEARCH("*"&D$1:D$180,A1),D$1:D$180)
C1 =SUBSTITUTE(A1,B1,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ­ã´£³¡ªL


    ÁÂÁ¤j®v´£¨Ñªº¤½¦¡,³]·Qªº¶g¨ì
joyce

TOP

¦^´_ 7# ML089


    ÁÂÁ±z
joyce

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD