往上提取日期與时间 (10472)

C4 下拉=IF(ISERR(FIND("号",A4)),"",LEFTB(A4,2)*1)

D4 下拉=IF(C4="","",-LOOKUP(1,-A$2:A3))

E4 下拉=IF(C4="","",MIDB(LOOKUP(1,0/(MID(A$2:A3,2,1)="栋"),A$2:A3),4,2)*1)

F4:I4 下拉=IFERROR(-LOOKUP(9,-MID($A4,FIND(F$1,$A4)+LEN(F$1),ROW($1:$9))),"")