ANGELA

¦X¨Ö¤å¦r.zip (12.4 KB)

¤U¸ü¦¸¼Æ: 4

2011-4-1 13:01

¨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