每二字元之間插入符號 (12648)

C2:G6=REPLACE(B2,COLUMN(A1)*3,,"-")

單格顯示=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B2,3,,"-"),6,,"-"),9,,"-"),12,,"-"),15,,"-")



留言