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

[µo°Ý] «ü©w¦r¤¸°ÝÃD½Ð±Ð

[µo°Ý] «ü©w¦r¤¸°ÝÃD½Ð±Ð

DEAR  SIR
1. RANGE("I10")= S(H)(ù)(280.3)
2.RANGE("A10") ¨Ï¥Î¨ç¼Æ = MID(I10,SEARCH("(",I10)+1,SEARCH(")",I10)-SEARCH("(",I10)-1)
  2.1 µª®×±o  H
3.½Ð±Ð­Y§Ú·Q±o¨ì 280.3 ´N¬O§ï¥Ñ¦r¤¸³Ì«á¤è¶}©l§ä   (  »P  ) ½Ð°Ý¨ç¼Æ¦p¦ó®Ñ¼g
    ÁÙ¬O­n¥Î VBA
4.·Ð¤£§[½ç±Ð.  THANKS*10000
ù

¦^´_ 1# rouber590324


   ±z¦n! ¥H¤U¤£ª¾¹D¬O¤£¬O±z»Ý­n£xQQ

= MID(I10,SEARCH("(",I10,7)+1,SEARCH(")",I10,7)-SEARCH("(",I10))

TOP

DEAR SIR
1­«ÂI  7 «D©T©w ­Y=   S(H)(ù)(H)(280.3) ´N¤£¾A¥Î
2.§Ú«á¨Ó·Q¨ì±N (H)»P(ù)¦p¤U¨ú¥N¬°ªÅ¥Õ
    ¦p¦¹³Ñ1²Õ () §Y¥i¥¿½T¨ú±o 280.3  THANKS

    =SUBSTITUTE(I10,"(ù)","")
   =SUBSTITUTE(I10,"(H)","")
ù

TOP

DEAR  SIR
1. RANGE("I10")= S(H)(ù)(280.3)
2.RANGE("A10") ¨Ï¥Î¨ç¼Æ = MID(I10,SEARCH("(",I10)+1,SEA ...
rouber590324 µoªí©ó 2015-5-12 13:38


A10 :
=-LOOKUP(,-MID(I10,FIND("/",SUBSTITUTE(I10,"(","/",3))+1,ROW(1:9)))

TOP

DAER   JBY  SIR
I10Åܦp¤U´NµLªk°Õ.¤´·PÁ±z¤§¤è¦¡.¨ü±Ð­ù  THANKS*10000
S(H)(ù)(H)(280.3)
ù

TOP

DAER   JBY  SIR
I10Åܦp¤U´NµLªk°Õ.¤´·PÁ±z¤§¤è¦¡.¨ü±Ð­ù  THANKS*10000
S(H)(ù)(H)(280.3)
rouber590324 µoªí©ó 2015-5-12 16:31


=-LOOKUP(,-MID(I10,MIN(FIND({0;1;2;3;4;5;6;7;8;9},I10&5^19)),ROW($1:$30)))

TOP

DAER   JBY  SIR
¤Ó±j°Õ. §ÚÁÙ¨S¬Ý¹L¦p¦¹¥Îªk.100%²Å¦X»Ý¨D. ¨ü±Ð©Ô THANKS*10000
ù

TOP

¦^´_ 1# rouber590324


=-LOOKUP(,-RIGHT(SUBSTITUTE(I10,")",),ROW($1:$9)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

DAER   ML089  SIR
100%²Å¦X»Ý¨D. ¨ü±Ð©Ô THANKS*10000
ù

TOP

DEAR  ALL¤j¤j
½Ð±Ð¬°¦ó¨Ï¥Î¹Ï¤@¤½¦¡ - ¬A¸¹¤º¤§­È = -280.3  ¦ý ¥N¥X¬°  280.3
- ¤£¨£°Õ  : À³¥N¥X  -280.3  ·Ð¤£§[½ç±Ð.  THANKS*10000
S(H)(ù)(H)(-280.3)

¹Ï¤@
=-LOOKUP(,-RIGHT(SUBSTITUTE(I10,")",),ROW($19)))

=-LOOKUP(,-MID(I10,MIN(FIND({0;1;2;3;4;5;6;7;8;9},I10&5^19)),ROW($130)))
ù

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD