作者cvv00010 (谬论)
看板Office
标题[算表] 如何断行
时间Thu Sep 14 16:02:15 2023
软体:Excel
版本:365
原始资料：中间只要有空格都是空3格
希望可以将资料断行如附图
https://i.imgur.com/G1yBDTX.jpg
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 101.136.60.89 (台湾)
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Office/M.1694678537.A.016.html
1F：推 windknife18: =TEXTSPLIT(SUBSTITUTE(TEXTJOIN(",",0,1:1) 09/14 16:26
2F：→ windknife18: ,",,","#"),",","#",1,,"") 09/14 16:26