How excel word wrap-CodePudding

CodePudding user response:

Because the number of lines is more, don't want to line to the point of ALT + ENTER

CodePudding user response:

refer to the second floor chang_bo response:

Width is useless

CodePudding user response:

With the second floor set "word wrap" feature, function is used to implement automatic newline within the cell

CodePudding user response:

Suppose A1 for id number
=LEFT (A1, 10) & amp; CHAR (10) & amp; RIGHT (A1, LEN (A1) - 10)
Cooperate with 2 floor plan: cell set "word wrap" feature,
Function is used to implement automatic newline within the cell

Leakage formula, make up

CodePudding user response:

Fifth floor truth! You can use!

CodePudding user response:

Word wrap + formula, you can refer to the following address:
http://jingyan.baidu.com/article/9c69d48f468c6e13c9024e9c.html

CodePudding user response: