把空格变成换行符,自动换行
replace($$$," ","\n")
自己选择不同的公式看结果:
JOINARRAY(GREPARRAY(split(replace($$$," ","@"),"@"),len(item)>0),"\n")/*每一行就一个换行符号*/
replace($$$, " ", "\n")/*有多少空格,返回多少换行符号*/
REPLACE(A1," ","\n")
注意" " 这里面要加空格 你看看你那个空白的是几个空格 就按几下空格