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

§ì¨ú¯S®í²Å¸¹«eªº¦r¦ê

§ì¨ú¯S®í²Å¸¹«eªº¦r¦ê

°ÝÃD¡G
BÄæ¬O­n§ì¨úAÄ椺²Å¸¹(«e­±ªº¦r¦ê¡F­YAÄ椺¨S¦³²Å¸¹(¡A«hBÄ椺§ì¨úAÄæÀx¦s®æªº­È

§ì¨ú¯S®í²Å¸¹«eªº¦r¦ê.zip (9.63 KB)

joyce

¦^´_ 1# leiru


    B2=IF(ISERR(FIND("(",A2,1)),A2,LEFT(A2,FIND("(",A2,1)-1))

TOP

¦^´_ 2# samwang


    ÁÂÁÂ
joyce

TOP

¦^´_ 1# leiru


    B2 =LEFT(A2,FIND("(",A2&"(")-1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ÁÂÁ±zªº¦^ÂÐ,
½Ð°Ý¬°¦ó­n¥[=F2&"(",¤£À´·N«ä
joyce

TOP

¦^´_ 5# leiru

¦ó­n¥[=F2&"("

­Y¦r¦ê¤¤¨S¦³ "(" ³o²Å¸¹®É¡A¥i¥HÅýFIND§ä¨ì³Ì¤@­Ó¦r+1

¨Ò¦p
¦r¦ê1 ="ABC(123)" & "("  ¤£¼vÅTFIND§ä¨ì²Ä¤@­Ó"("
FIND("(",¦r¦ê1 ) = 4

¦r¦ê2 ="ABC" & "("  FIND·|§ä¨ì¥[¦b¦r§Àªº"("
FIND("(",¦r¦ê2 ) = 4
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


    ÁÂÁ¸Բӻ¡©ú
joyce

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD