- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¥»©«³Ì«á¥Ñ ANGELA ©ó 2013-9-6 20:51 ½s¿è
§âC2¤½¦¡§ï¦¨=SUBSTITUTE(SUBSTITUTE(MID(A2,IF(ISERROR(SEARCH("}",A2,1)),SEARCH(")",A2,1),SEARCH("}",A2,1))+2,LEN(A2)-IF(ISERROR(SEARCH("}",A2,1)),SEARCH(")",A2,1),SEARCH("}",A2,1))-2),"(",),")",)©¹¤Ucopy
C13=--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),1,50)
D13=--MID(SUBSTITUTE(C2,"+",REPT(" ",50)),51,50)
E13=IF((LEN(C2)-LEN(SUBSTITUTE(C2,"+",)))<2,"",--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),101,50))
F13=IF((LEN(C2)-LEN(SUBSTITUTE(C2,"+",)))<3,"",--MID(SUBSTITUTE($C2,"+",REPT(" ",50)),151,50))
B2=IF(ISERROR(SEARCH("{",A2,1)),MID(A2,SEARCH("(",A2,1),SEARCH(")",A2,1)-SEARCH("(",A2,1)+1),MID(A2,SEARCH("{",A2,1),SEARCH("}",A2,1)-SEARCH("{",A2,1)+1)) |
|