拆分空白 二部份 (10612)

日期：


B2:C8=TRIM(MID(SUBSTITUTE(TRIM($A2)," ",REPT(" ",99)),COLUMN(A1)*99-98,99))


B2:C2 區域數組 下拉{=TEXT({1,-1}%,""""&SUBSTITUTE(TRIM(A2)," ",""";""",1)&"""")


留言

張貼留言