每n个单词后如何将文本拖到新段落中 [英] How to slip text into new paragraph after every n words

问题描述

我在excel中工作.说我有一个文字->一二三四五五六七八九十.现在，如果我想在每3个字后更改段落行-

I am working in excel . Say i have a text --> one two three four five six seven eight nine ten . Now if i want to change paragraph line after every 3 words -

一二三

四五六

七八九

十个

如果在excel中可以，请告诉我.或者，如果还有另一种方法

Tell me if this is possible in excel . Or if there is another way to do it

推荐答案

我猜想在Excel中执行'OK'.但是您需要ExcelO365或Excel 2019随附的CONCAT.将ExcelO365一起使用以使用SEQUENCE会很方便.例如:

It's 'OK' to do in Excel I'd guess. But you'd need CONCAT which comes with ExcelO365 or Excel 2019. And it would be handy to have ExcelO365 alltogether to use SEQUENCE. For example:

A2中的公式:

=CONCAT(IF(MID(A1,SEQUENCE(LEN(A1)),1)=" ",IF(MOD(LEN(LEFT(A1,SEQUENCE(LEN(A1))))-LEN(SUBSTITUTE(LEFT(A1,SEQUENCE(LEN(A1)))," ","")),3)=0,CHAR(10),MID(A1,SEQUENCE(LEN(A1)),1)),MID(A1,SEQUENCE(LEN(A1)),1)))

该公式的中心是MOD，它指示三个表中是否有任何空格.如果是这样，在将字符串重新连接在一起之前，我们用换行符替换它.

At the centre of the formula is MOD which tells if the placement of any space is in the table of three. If so, we replace it with a newline before we concatenate the string back together.

这篇关于每n个单词后如何将文本拖到新段落中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！