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

[µo°Ý] ¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O

[µo°Ý] ¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O

½Ð±Ð¤j®a
¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O
(http://mis.twse.com.tw/)
§Ú¦³¥Î¹L ¶×¤J¥~³¡ºô­¶¸ê®Æ ¨S¦³¥Î
¥Îyahooªº¥i¥H¥¿±`Ū¨ú

½Ð±Ð¤j®a ¸Ó«ç»òŪ¨ú©O
ÁÂÁÂ

¤j®a¦n
§Ú¤w¸g³z¹Lexcel§ì¨ì¸ê®Æ
¦ý§ì¨ìªº¬O1­ÓÀx¦s®æÅã¥Ü 1,"09:34:15","8925.58","0.49"
½Ð°Ýexcel­n§â8925.58§ì¥X¨Ó
¬O¦³¤°»ò«ü¥O¥i¥H¥Î¶Ü
ÁÂÁÂ

TOP

§Ú­èTRY
¥Î¤F¦³ÂI²Âªº¤èªk
´N¬O¨Ï¥Î =RIGHT(J4,16) ¥ý¨ú¥X 8955.83","30.74"
¦A¥Î =LEFT(L3,7) §ì¥X8955.83¥X¨Ó
¦³¤H¦³§ó¦nªº¤èªk¶Ü
ÁÂÁÂ

TOP

¦^´_ 2# JERRYHUANG123


    =--LEFT(SUBSTITUTE(A1,LEFT(A1,FIND(""",""",A1)+2),""),FIND(""",""",SUBSTITUTE(A1,LEFT(A1,FIND(""",""",A1)+2),""))-1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂH¤jªº±Ð¾É
¥i¥H¥Î¤F ¦Ó¥B¤]ª½±µÂন¼Æ¦r ¥i¥H¹Bºâ
¤]·|ÀHµÛ¼Æ¦rªºªø«× ¦Û°Ê§ì¨ú
·PÁÂ

TOP

©w¸q
A=EVALUATE("{"&Sheet1!$A$1&"}")
A2=--INDEX(A,,3)

Book1.rar (1.59 KB)

1

µû¤À¤H¼Æ

    • Hsieh: good ideaª÷¿ú + 4
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 6# gong

±N³r¸¹³sµ²¤å¦rµø¬°°}¦C
¤@¯Å´Îªº«ä¸ô
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-4-25 14:46 ½s¿è

¥t¤@°Ñ¦Ò
=--SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",100)),200,100)),"""","")

­n¦³¸ê®Æ­åªRªº®ÄªG¥i§ï¦¨

=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",200)),COLUMN(A1)*200-199,200))
1

µû¤À¤H¼Æ

TOP

¥t¤@°Ñ¦Ò
=--SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",100)),200,100)),"""","")
ANGELA µoªí©ó 2011-1-18 15:07



    ¯u¤£Â²³æ,¥Î¤F³o»ò¦hºØ¨ç¼Æ,«D±o¨ç¼Æºë³q¤£¥i
¥ú¬Ý«ä¸ô´N­nÂà¨ÓÂà¥h,¥i¨£±o¥Î¥\¤§²`¤J
¥[¤À¹ªÀy

¤Ï¥¿­n¥[»²§U¦C,¤]¤£®t¦h´XÄæ,¥Î¸ê®Æ­åªR¤]¥i¥H
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

½Ð°Ý
§Ú¤@­ÓÀx¦s®æ ·|¶×¤J¥H¤Uªº¸ê®Æ
1102,"0.05","13:30:05","33.55","29.25","31.3","31.7","31.3","31.45","3995","221","31.45","4","31.4","338","31.35","74","31.3","276","31.25","279","31.5","53","31.55","20","31.6","19","31.65","135","31.7","222","0","1","01","1000","3075307547","¨Èªd  "

¤]´N¬O­ÓªÑªº³ø»ù  ·Q­n®³¤¤¶¡ªº¤@¨Ç­È¨Ó¹Bºâ
§Ú¨Ï¥Î¸ê®Æ­åªR ¥i¥H§â§Ú­nªº¸ê®Æ¤ÀÂ÷¥X¨Ó°µ¹Bºâ
¦ý¬O¥Î¸ê®Æ­åªRªºÀx¦s®æ «oªk¿ìªk¨C¤ÀÄÁ§ó·s
½Ð°Ý¦³¤°»ò¤èªk¥i¥HÅý¸ê®Æ­åªR«áªºÀx¦s®æ¨C¤ÀÄÁ§ó·s©O
¦]¬°§Ú­ì¨ÏªºÀx¦s®æ ·|¨C¤À§ó·s¤@¦¸
ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD