單格多行日期,要如何用剖析 (12671)

B2=SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(PHONETIC(A$2:A9),"-",),CHAR(10),),".",REPT(" ",99)),ROW(A1)*198-197,198))," ",".")