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

[µo°Ý] Â^¨ú¯S©w¤å¦r¤§«áªº¤å¦r¤Î¤é´Á®É¶¡

[µo°Ý] Â^¨ú¯S©w¤å¦r¤§«áªº¤å¦r¤Î¤é´Á®É¶¡

§Ú¦³¨â­Ó»Ý¨D
°ÝÃD1.¬O­nÂ^¨ú<¶}©l>¤§«áªº¤å¦r,­nÅã¥Ü¦bGÄæ2
°ÝÃD2.¬O­nÂ^¨ú<¶}©l>¤§«áªº¤é´Á®É¶¡,­nÅã¥Ü¦bHÄæ2
¥H¤U¸ê®Æ,¬Ò¦b¦P¤@FÄæ2¸Ì­±

¡u½¹½º¡ã½¹½º¡ã¥Í±o¯u¬üÄR¡ã¡v¬Û«Hª¨ª¨¶ý¶ý¤@©w±`¦³¦bÄ_Ä_¦ÕÃä»´­ó¨àºqªº¸gÅç¡A«Ü¦hºq¦±¤]³£¬Oª¨¶ý¦Û¤v¤p®É­Ô±q¤j¤H­Ì¨º¨àÅ¥¨Óªº¡A¥N¥N¬Û¶Ç¦nµ£ÁÁ¡A¦ÊÅ¥¤£¿°¡A­ó°Û®Éªºªº²´¯«·f°tªÏÅé°Ê§@¡A«Ä¤lµL¤£³³¾K¦b¬ü§®ªº­µ¼Ö±Û«ß¸Ì¡A¦n¦nµ½¥ÎÀH¨­Äâ±aªº­µÅT¡Ð¼L¤Ú¡AÀH®ÉÀH¦aµ¹¤pÄ_¨©¤@­º¸g¨åªº¨àºq¡A±q²âÅ¥ºqÁn¤¤¡A·P¨ü­µ¼Ö±a¨Óªº¾y¤O¡C

<¶}©l>½¹½º¨àºq/2019/3/14 10:05

<µ²§ô>2019/3/15 12:30
---------------------------------------------------------

§Ú¸Õ¹Lªº¤èªk:
¦bGÄæ2,¤Uªº¨ç¼Æ¬°:=FIND("¯d¨¥",F3,1)
¦bHÄæ2,¤Uªº¨ç¼Æ¬°:=MID(F3,159,4)
·|Åã¥Ü:½¹½º¨àºq
¦ý¦pªG¨C­ÓÄæ¦ì©ÒÅã¥Üªº¦r¼Æ¤£¦P,§Úªº¤èªk¬O¤£¾A¥Îªº!!
½Ð°Ý§Ú¸Ó¤U¤°»ò¨ç¼Æ©O?(¦P°ÝÃD1.)

ÁÂÁÂ

¬O§_¦p¦¹
F1= <¶}©l>½¹½º¨àºq/2019/3/14 10:05
G1= =MID(F1,FIND(">",F1)+1,FIND("/",F1)-FIND(">",F1)-1)
H1= =MID(F1,FIND("/",F1)+1,99)

TOP

G2 =TRIM(LEFT(SUBSTITUTE(MID(F2,FIND("<¶}©l>",F2)+4,99),"/",REPT(" ",99)),99))
H2 =TEXT(-LOOKUP(,-MID(F2,FIND("/",F2,FIND("<¶}©l>",F2))+1,ROW($1:$20))),"yyyy/m/d hh:mm")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤£¦n·N«ä,§Ú­è­è¸Õ¹L¤F
§Ú¥u­nÂ^¨úG2Äæ¦ì,<¶}©l>¤Î¤é´Á®É¶¡¤§¶¡ªº¤å¦r


<¶}©l>½¹½º¨àºq/2019/3/14 10:05

½Ð°Ý¦³¤èªk¶Ü?ÁÂÁÂ

TOP

¦pªG,§Ú§ï¬°
G2 =TRIM(LEFT(SUBSTITUTE(MID(F2,FIND("<¶}©l>",F2)+4,99),"/",REPT(" ",4)),4))
´N¥i¥HÂ^¨ú¨ì§Ú­nªº¦r,¦ý¦pªG¨C­ÓÄæ¦ì©ÒÅã¥Üªº¦r¼Æ¤£¦P,¸Ó«ç»ò°µ©O?ÁÂÁÂ

TOP

¦^´_ 5# milk609609

99 ´N¬O´¡¤J 99­ÓªÅ¥Õ¡A¹ï¤£©wªø«×¤ñ¸û¦³¼u©Ê
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


    ¦³¤F¦³¤F,­ì¨Ó¦bªº«e­±"",§Ú¨S¦³¥[¤@­ÓªÅ¥ÕÁä,ÁÂÁ±z
¤]ÁÂÁÂikboy

TOP

¦^´_ 7# milk609609


    REPT(" ",99)),99))
¦bÂù¤Þ¸¹,¸Ì­±¦³­ÓªÅ¥ÕÁä,´N¥i¦æ¤F,·PÁÂ

TOP

¦^´_ 6# ML089


    ½Ð°ÝML089¦Ñ®v:
¥H¤U¤T­Ó¨ç¼Æ,¦pªG¦bÄæ¦ì¦³§Ú­nªº¸ê®Æ,´N³£¨S°ÝÃD,¦ý¦pªG¨S¦³§Ú­nªº¸ê®Æ®É,´N·|¥X²{#N/A,Äæ¦ì¥i¥HÅã¥ÜªÅ¥Õ¶Ü?ÁÂÁ±z

¶}©l®É¶¡
TEXT(-LOOKUP(,-MID(F2,FIND("/",F2,FIND("<¶}©l>",F2))+1,ROW($F:$F))),"yyyy/m/d hh:mm")

¶}©l¤º®e
TRIM(LEFT(SUBSTITUTE(MID(G4,FIND("<¶}©l>",G4)+4,99),"/",REPT(" ",99)),99))

µ²§ô®É¶¡
IFERROR(TEXT(-LOOKUP(,-RIGHT(F2,ROW($F:$F))),"yyyy/mm/dd hh:mm"),"")

TOP

¦^´_ 9# milk609609


  ¨Ï¥Î IFERROR( ­ì¤½¦¡, "")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD