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

[µo°Ý]¤ÀÃþ¾ã²z°t¤è»Ý­n¶q

B2¡BC2¤½¦¡Â²¤Æ
  1. B2=MID(A2,2,-LOOKUP(,-FIND({")(","}{"},A2))-1)
  2. C2=MID(A2,-LOOKUP(,-FIND({")(","}{"},A2))+1,99)
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ´£¨Ñ²¤Æ
¬ã¨sANGELA©MML089µ¹ªº¤½¦¡
®M¥Î¨ì²{¦³¥þ³¡°t¤è¤¤
µo²{ÁÙ¬O¦³¨Ç°t¤è·|¥X°ÝÃD
¦n¹³¬O¦³¨Ç¯S§O°t¤è©R¦W¤ñ¸û¤£¦P
°t¤è3.rar (5.95 KB)
¦p¡GB(c+d)(3+120du+8)¡BC(e+f)(2+3hr+1.5atm+5)
         F{C(e+f)+k}{(2+3hr+1.5atm+5)+8hr+6)}
§Ú¦A¦h¾ã²z¤@¨Ç¤ñ¸û©_©Çªº°t¤è
¦A¦¸·PÁ¦U¦ìªº¦^ÂÐ

TOP

¦^´_ 12# rakefrank

¤½¦¡¤À¸Ñ¦¨B¡BCÄæ³£¨S¦³°ÝÃD
¤§«e¦¨¥÷¦WºÙ»P¥÷¦W¥÷¶q¬O¤@¹ï¤@¡A«á¨Óµ¹ªºÅܦ¨¤£¬O¤@¹ï¤@±¡ªp?

§AÀ³¸Ó§ä¤@¨Ç¼Ð·Ç®æ¦¡(¤j³¡¤À)¤Î¯S¨Ò®æ¦¡¡A¨Ã§â§A§Æ±æ¨ú¥X¨Óªº®æ¦¡¤Î­È§@¤@­Ó¬O½d¨Ò¡A¤~¯àºë·Çµû¦ô¨Ï¥Î¤è¦¡¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089

³y¦¨§xÂZ¯uªº«Ü©êºp
¦]¬°§Ú¤]¬O­è±µ³o­ÓªF¦è
¬Ý¨ì¤å¦rÀɮɧھã­Ó¶Ì²´
´N¶}©l¤H¤uºCºC¾ã²z
«á¨Ó·Q¨ìexcel¦³¨ç¼Æ¥i¥H¨Ï¥Î
¶}©l·Q¦p¦ó¥Î¨ç¼Æ°Ï¤À
¥B¦A¸g¦U¦ì¥ý¶i«ü¾É
µo²{¯uªº«Ü¦n¥Î

¦ý§Ú±N§ó¦h°t¤è©ñ¶i¨Ó®É
´Nµo²{°ÝÃD·U¨Ó·U¦h¤F

³o¨Ç¤å¦rÀɦ³¤W¦Ê­Ó
¸Ì­±¤]¦U¦³¤W¦Ê­Ó°t¤è

¤@¶}©lªº°t¤è¥u¦³³æ¯Âªº¼Æ¶q
¦ý«á¨Ó¦]¬°±ø¥ó·U¨Ó·U¦h
©Ò¥H¤]±N±ø¥ó¥[¤J¨ì°t¤è¤¤
¦pªG¦WºÙ»P¼Æ¶q¤£¬Û¦Pªº³¡¥÷µLªk¥Î¨ç¼Æ©î¸Ñ
¨º§Ú¥u¦³¥H¤H¤u¨Ó°µ

¨Ó³o¸Ì¯à¦h¾Ç¨ì¤@¨Ç¤j®a¼g¨ç¼Æªº«äºû¤Î§Þ¥©¤~¬O³Ì­«­nªº¡I

TOP

¦^´_ 14# rakefrank
  1. B2 =MID(A2,2,-LOOKUP(,-FIND({")(","}{"},A2))-1)
  2. C2 =MID(A2,-LOOKUP(,-FIND({")(","}{"},A2))+1,99)
  3. D2{ =MID($B2,SMALL(IF(LOOKUP(CODE(MID($B2,ROW($1:$22),1)&0),{0,97,123},{0,1,0}),ROW($1:$22),99),COLUMN(A:A)),1) }
  4. E2{ =TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE($C2,"+",REPT(" ",99)),COLUMN(A:A)*99-98,99),"(",),")",),"{",),"}",)) }
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ML089

·PÁ´£¨Ñ
³o­Ó§Ú­n¦n¦n¬ãŪ¤@¤U¤~¯à°÷¤F¸Ñ

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD