EXCEL如何打乱单元格内长句子的单词顺序？

Question

就比如说，句子是there is nothing we can do but crying. 在下一行 变成is nothing we can do there there crying. 需要怎么操作可以批量得到新结果呢。

Answer 1

=MID(A1,FIND(" ",A1)+1,99)

向右拖动，则往后一列就少一个单词

向下拖动也是一样。

需要什么结果就看你的选择了。

Answer 2

B1:

=TEXTJoin(" ",,FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,RIGHT(A1),""),",","")," ","</b><b>")&"</b></a>","//b["&N(IF({1},MOD(SMALL(RANDBETWEEN(ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1))^0,1000)*100+ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1)),ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1))),100)))&"]"))&RIGHT(A1)

ctrl+shift+回车

Answer 3

在表格当中，打乱单元格内长句子的单词顺序，可以直接就是使用乱码的顺序或者直接用数据。追问

怎么做呢