- ©«¤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 ©ó 2011-4-1 13:32 ½s¿è
¦X¨Ö¤å¦r.zip (12.4 KB)
¨S²Ó¬Ý,¥H¬°ªÅ®æ¬O¤@Pªº,ì¨Ó¦³¨º»ò¦hºØ,³o¤½¦¡½T¹ê¤£¾A¥Îקï¦p¤U
©w¸q¦WºÙ: xx=LEN(°ÝÃD!$A2)-LEN(SUBSTITUTE(°ÝÃD!$A2," ",))
C2 =TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"B","C","D","E"})&1))*100+1,100))
E2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"C","D","E","F"})&1))*100+1,100))
F2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"D","E","F","G"})&1))*100+1,100))
G2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"E","F","G","H"})&1))*100+1,100))
D2 ¥ÎÅǪ©¥D,Áª©¥Dªº¤èªk¥Î´À¥N§Y¥i.
¤]¥i§ï¦¨
E2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),(MATCH(XX,{5,6,7,8},)+COLUMN(B1))*100+1,100)) ©¹¥kCOPY ¨ìG2 |
|