[算表] 如何斷行

[cvv00010 (謬論)]

軟體:Excel

版本:365


原始資料：中間只要有空格都是空3格

希望可以將資料斷行如附圖

https://i.imgur.com/G1yBDTX.jpg

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.136.60.89 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1694678537.A.016.html
推 windknife18: =TEXTSPLIT(SUBSTITUTE(TEXTJOIN(",",0,1:1)
→ windknife18: ,",,","#"),",","#",1,,"")