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

[µo°Ý] ¦pªGÄæ¦ì¨S¦³§Ú­nªºªF¦è,´NÅã¥ÜªÅ¥Õ(¨ç¼Æ­n¥[¦b­þ¸Ì?)

[µo°Ý] ¦pªGÄæ¦ì¨S¦³§Ú­nªºªF¦è,´NÅã¥ÜªÅ¥Õ(¨ç¼Æ­n¥[¦b­þ¸Ì?)

½Ð°Ý¥H¤U2­Ó²[¼Æ,§Ú­n¦A¦h¤@­Ó»Ý¨D,¦pªGG2Äæ¨S¦³§Ú­nªºªF¦è,´N¦bJ2Äæ¤ÎK2ÄæÅã¥ÜªÅ¥Õ


1.¦¹¨ç¼Æ¦bJ2Äæ:
=TEXT(-LOOKUP(,-MID(G2,FIND("/",G2,FIND("<¶}©l>",G2))+1,ROW($G:$G))),"yyyy/m/d hh:mm")

2.¦¹¨ç¼Æ¦bK2Äæ
=TRIM(LEFT(SUBSTITUTE(MID(G2,FIND("<¯d¨¥>",G2)+4,99),"/",REPT(" ",99)),99))

§Ú¦³¦b¨ç¼Æ«e­±,¤UIF(G2="","",),¦ý³£Åã¥Ü#N/A¤Î#VALUE!

ÁÂÁÂ

¦^´_ 1# milk609609

=IF(G2="","", ­ì¦³¤½¦¡)
­Y¦³°ÝÃD´N¬O G2¤£¬O ""¡A¥i¥H¦b¤½¦¡½s¿èÄ椤¿ïG2«öF9¬Ý¬ÝG2¬O¤°»ò
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD