JBY

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)))

rouber590324

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)","")

gn001038600

¦^´_ 1# rouber590324


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

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