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

§â¦³±×½uªº¤å¦rÀx¦s®æ§ä¥X,¦A¬A©·°_¨Ó?

§â¦³±×½uªº¤å¦rÀx¦s®æ§ä¥X,¦A¬A©·°_¨Ó?

¬¶¤Ñ¶¯(¦æ¬¶¥I)
¤j归§À/当归§À
ªê¨Å
¯ó乌¤ù
¥Õ¤C¨½/ã°òÔ
¥¿¨¦ºë¤l
¯ó决©ú/决©ú¤l
温ª÷¤ù/­§ª÷¤ù/¤Aª÷¤ù

1)¦p¦ó§ä¥X¦³±×½u(/)ªºÀx¦s®æ?
2)¦A±N¥Ñ±×½u(/)¶}©lÀx¦s®æ¤ºªº¦r¬A©·°_¨Ó.

­ì¥»¸ê®Æ:
¤j归§À/当归§À

½s¿è¦Z:
¤j归§À(当归§À)

¥»©«³Ì«á¥Ñ Eugene ©ó 2011-7-4 22:59 ½s¿è

¦^´_ 1# Qin

    =IF(ISERROR(FIND("/",A1)),A1,LEFT(A1,FIND("/",A1)-1)&"("&RIGHT(A1,LEN(A1)-FIND("/",A1))&")")

¤£¹L¡A"温ª÷¤ù/­§ª÷¤ù/¤Aª÷¤ù"·|Åܦ¨"温ª÷¤ù(­§ª÷¤ù/¤Aª÷¤ù)"¡C¥i¥H¦A°Ñ¦Ò LEN ¤Î REPLACE¡A¥h¼g§PÂ_¦¡¡AÅܦ¨±z·Q­nªº¼Ë¦¡¡C

TOP

¦^´_ 1# Qin


    =SUBSTITUTE(SUBSTITUTE(A1&")","/",")("),")","",1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh


    ÁÂÁª©¤j¡A¦h¾Ç¤F­Ó¨ç¼Æ¡C"SUBSTITUTE" ¤è«K¦h¤F¡I

TOP

¹ï¤£°_,¤v¹L¤F³\¤[ªº³o½g¤å³Q½¤F¥X¨Ó¡C¦ý¬OHSIEH¤j¤jµ¹¤©ªº¤½¦¡Åý¾Ç¥Í¦³¨ÇºÃ´b¡C
½Ð°Ý¦U¦ì¥ý¶i,¨Ì·Ó¼Ó¥Dªº°ÝÃD,HSIEH¤j¤jµ¹ªº¤½¦¡¯à°µ¥X¥¿½Tªºµª®×,Åý¾Ç¥Í²´·ú¬°¤§¤@«G¡C¦ý¬O³o¦æ¤½¦¡¾Ç¥Í¬Ý¤F³\¤[,ÁÙ¬O¤£¤ÓÀ´,Àµ½Ð¦U¦ì¥ý¶i«ü±Ð¡C

®Ú¾ÚHSIEH¤j¤jªº¤½¦¡:

=SUBSTITUTE(SUBSTITUTE(A1&")","/",")("),")","",1)

¸Ì¦æ¤½¦¡¸ÌªºA1&")" ©M³Ì¥½ªº1,«üªº¬O¤°»ò·N«ä©O¡H

Àµ½Ð¦U¦ì¥ý¶i­@¤ß«ü±Ð,ÁÂÁÂ!

TOP

¦^´_ 5# smmriyonk


    ³o­Ó¤½¦¡¥]§t2¼hªºSUBSTITUTE¨ç¼Æ
¥ý¬Ý¤º¼hSUBSTITUTE(A1&")","/",")(")
¥HA1¬°"温ª÷¤ù/­§ª÷¤ù/¤Aª÷¤ù"¬°¨Ò
A1&")"´N¦¨¤F
温ª÷¤ù/­§ª÷¤ù/¤Aª÷¤ù)
¦A±N±×½u¥Î")("¨ú¥N
´N·|¦¨¬°
温ª÷¤ù)(­§ª÷¤ù)(¤Aª÷¤ù)
³o¼Ëªº¦r¦ê¸ò­n¨Dªºµª®×·|¦h¤F²Ä¤@­Ó¬A¸¹")"
¥~¼hSUBSTITUTE
´N¦¨¤F=SUBSTITUTE("温ª÷¤ù)(­§ª÷¤ù)(¤Aª÷¤ù)",")","",1)
³o­Ó¨ç¼Æ¦h¤F²Ä4­Ó¤Þ¼Æ1
³o­Ó¤Þ¼Æ¥i¥H«ü©w²Ä´X­Ó«ü©w¦r¦ê³Q¨ú¥N
¤]´N¬O±N²Ä1­Ó¬A¸¹")"¥ÎªÅ¦r¦ê""¨ú¥N
³o¼Ë´N¯à¹F¨ì­n¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ¤Ó¯«©_¤F....
¨S·Q¨ìHSIEH¤j¤j³o»ò§Ö´N¦^ÂФF¾Ç¥ÍªººÃ´b,¦V±z­P¤W¤Q¤G¸U¤ÀªºÁ·N¡C
·PÁ¤j¤j­@¤ßªº«ü¾É,¾Ç¥Í¤]¤F¸Ñ³o¦æ¤½¦¡ªº§¹¾ã·N«ä¤F¡C­ì¨Ó¦b¤½¦¡¸Ì,A1&")",¥i¥Hª½±µ±N")"²Å¸¹±a¤JA1¦r¦êªº³Ì§À³B,¾Ç¥Í¯u¬O¨ü±Ð¤F,ÁÂÁÂHSIEH¤j¤j,·PÁ±z!

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD