New questions about line breaks in cells in Excel

xue5583307

I want to input 100 Chinese characters in a cell in one cell. Because there are thousands of data, I use word wrap, but the word wrap in EXCEL format cannot be kept when I copy it to a WORD or .TXT file. The addition of "Enter" and "ALT + Enter" are actually different. I would like to ask prawns how to specify a line of input in a cell (such as 100 Chinese characters) and then press + Enter, so that it is also entered when it is copied.

Can you see what I mean? ? That is to say, when I want to copy the contents of the cell, the format is the same as that shown in the table. When the line break in the cell is copied elsewhere, there should be a carriage return.

su27smk

You can create a new field and force a line break every 100 characters in Field 1.

Assuming that the number of characters in the cell you need to process is less than 300, you need to wrap at every 100 characters. The formula can be written as follows:

B2==MID(A2,1,100)&CHAR(10)&MID(A2,101,100)&CHAR(10)&MID(A2,201,100)

The MID() function sequentially takes out every 100 characters (you can continue to add according to your own needs)

char(10) is a newline symbol

Of course, the cell should be set to "Wrap" first.

After the test, the result can be recognized as a new line by WORD, and TXT is invalid.

vgf10002

The txt file has no format

xue5583307

Thank you prawn for your advice. I tried it to achieve the effect I wanted. Thank you~~~ :-)