| |

VerySource

 Forgot password?
 Register
Search
View: 25|Reply: 1

New questions about line breaks in cells in Excel

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-3-7 16:00:02
| Show all posts |Read mode
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.
Reply

Use magic Report

0

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-6-27 06:45:01
| Show all posts
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.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list