年月日提取 資料不規則 (13280)

C2=LOOKUP(1,0/FIND(" "&ROW($1900:$3000)&" "," "&B2&" "),ROW($1900:$3000))

D2=LOOKUP(1,0/FIND(TEXT(DATE(2024,ROW($1:$12),1),"MMMM"),B2),ROW($1:$12))

E2=LOOKUP(1,0/FIND(" "&ROW($1:$31)&"TH"," "&B2),ROW($1:$31))



留言