拆年月日並改變顯示 (12125)

C4:D7=TEXT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE($B$2,CHAR(10),"~"),"~",REPT(" ",99)),(ROW(A1)*2-2+COLUMN(A1))*99-98,99)),".","/"),"D/M/YYY")