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

[µo°Ý] ¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e

[µo°Ý] ¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e

»Ý­n±NAÄ檺¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e
½Ð°Ý­n¥Î¤°»ò¨ç¼Æ?
¥Ø«e·Q±o¨ì­n¥ÎFIND§ä¥XÃöÁä¦r LENºâ¥X¦r¤¸  «o¤£·|¼g:'(

Book1.zip (5.69 KB)

TOP

B2, ¤½¦¡¦V¥k½Æ»s

=-LOOKUP(1,-LEFT(REPLACE($A2,1,FIND("@",SUBSTITUTE($A2,":","@",COLUMNS($A1:A1))),""),ROW($1:15)))

TOP

¨ú¥X¯Â¼Æ¦r. ³Ì¦h15¦ì, µL0¶}ÀY¡G
¢Ð¢±¡G=-LOOKUP(,-MID($A2,FIND(B$1,$A2)+LEN(B$1),ROW($1:$15)))

TOP

http://blog.xuite.net/hcm19522/twblog/363756209

TOP

½Ð°Ý¦pªG¦³§¨Âø­^¤å¤¤¤å©O??

TOP

¤j¤j­Ì¦n
§Ú¥Ø«e·Q¨ì ¥i¬O³Ì«á¤@­Ó´N·| ¥X¤£¨Ó¤F@@
=MID($A$2,SEARCH(B1,$A$2,1)+LEN(B1),SEARCH(C1,$A$2,1)-1)

TOP

=MID($A$2,SEARCH(B1,$A$2,1)+LEN(B1),LEN($A$2)-SEARCH(C1,$A$2,1)-LEN(C1))

¼È®É©Ê¥i¥H¤F ¥i¬OÆZ®e©ö¥X¿ùªº~¨D§ó¦n±o¤èªk@@

ÁÙ¦³LOOKUP§Úª¾¹D
-LOOKUP¦h­Ó´î¸¹¬O¤°»ò·N«ä??
hcm19522¤j¤jªº..§Ú¬Ý¤£¤ÓÀ´QQ"~¦ü¥G¤£¬O§Ú»Ý¨Dªº?

TOP

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,C$1,B$1),B$1,REPT(" ",199)),199,199))

TOP

ÁÂÁÂ~¦n¦h¨ç¼Æ~­n¾Ç¾Ç¥Îªk¤F!

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD