...3, 2022 1:31:44 AM PST有年月日和时间,怎么提取:年、月、日、时...答:在 Excel 2007 中,可以用以下公式满足题述要求:1. 年:=MID(A2,FIND(",",A2)+2,4)2. 月:=MONTH(LEFT(A2,FIND(" ",A2))&-1)3. 日:=MID(A2,FIND(" ",A2)+1,FIND(",",A2)-FIND(" ",A2)-1)4. 时:=MID(A2,FIND("*",SUBSTITUTE(A2," ","*",3))+1,FIND("*",...