½Ð°Ý¥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!
ÁÂÁÂ |