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

½Ð°Ý¦p¦óÂ^¨ú¬A¸¹«eªº¤å¦r(¦ý¦P¤½¦¡«á­±¨S¬A¸¹¤]­n¥þ³¡Â^¨ú)

¦^´_ 8# chin15


   ³o¥i¯à¤]¥u¾A¥Î¤£·|Åܰʪº¸ê®Æ¦Ó¤w³á!

TOP

¦^´_ 1# eric866

B1¤½¦¡¦p¤U
=LEFT(A1,FIND("(",A1&"(")-1)
¤U©Ô½Æ»s
1

µû¤À¤H¼Æ

    • Hsieh: Áo©úªº°µªk¡A¤£©È§ä¤£¨ì¤À¹j¦r¤¸ª÷¿ú + 2
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089


    ÁÂÁ±z¥t¥~ªº¸Ñµª~excelªº¨ç¼Æ¦n¦hºØ¥Îªkªü

TOP

©Î

=REPLACE(A1,FIND("(",A1&"("),99,)

TOP

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-9-19 09:11 ½s¿è

¦^´_ 12# ML089


    ¨S·Q¹Lleft ¸ò find¤@°_¨Ï¥Î
   ½Ð°Ý=LEFT(A1,FIND("(",A1&"(")-1)  ¬°¤°»ò­n¥[³o¦U&"("
    §Ú¸Õ³o¦ULEFT(A1,FIND("(",A1)-1)¤]¯à¶]¥Xµ²ªG
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 15# freeffly

·íAÄæ§ä¤£¨ì"("³o¦r¤¸ªº®É­ÔFIND·|¶Ç¦^¿ù»~­È
¥ÎA1&"("¦ÛµM´N¤£»Ý­n¿ù»~³B²z¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 16# Hsieh


    ª¾¹D­ì²z¤F
   ÁÂÁª©¥D¸ÑÄÀ
   ªGµMÁÙ¬O­n¾Þ§@¬Ý¬Ý
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

B1=MID(A1,1,IF(ISERROR(FIND("(",A1)),LEN(A1),FIND("(",A1)-1))
B1=TRIM(LEFT(SUBSTITUTE(A1,"(",REPT(" ",50)),50))
¯u¬O¤dÅܸU¤Æ
¤S¾Ç¨ì¤£¤Ö

TOP

§V¤O¦^´_²Ö¿n¿n¤À¡A¦n¤É¨ì¤¤¾Ç¥Í¤U¸üÀÉ®×¼W¶i¾Ç²ß³t«×¡C

TOP

ªº½T¬O¦³¦hºØ¤£¦Pªº¤è¦¡¥h¹F¦¨¥Øªº¡A¨Ì
§Ú­Ó¤H¸û°¾¦n²¼ä¡B§ã­n¡Bª½±µ¤Á¤J­«ÂI¡C
¾Ç²ß¤F¥H¤W¼Ó¼hªº¦UºØ³B²z¤è¦¡¡A­ì«h¤W #2
Hsieh «e½úªº¼gªk»P§Ú­Ó¤HÆ[ÂI¹p¦P¡C¦pªG¬O
¹ê°È³B²z§Ú·|¸û°¾¦V¦¹µ¥Ãþ¦üªº§@·~¤è¦¡¡C

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD