How to divide a line of text into multiple lines in excel

How to split a line of text into multiple lines in Excel

In Excel, splitting a line of text into multiple lines can be achieved through the following steps:

1. Insert line breaks

• Select the text lines you want to split.
• On the Home tab, in the Editing group, click the Wrap button.

2. Use the ALT ENTER shortcut key

• to select the text lines you want to split.
• Hold down the ALT key at the end of the line you want to separate, and then press ENTER.

3. Use the TEXTJOIN function

To split the text into multiple lines according to the specified delimiter, you can use the TEXTJOIN function:

<code>=TEXTJOIN(分隔符, TRUE, 文本1, 文本2, ...)</code>

• The "delimiter" parameter specifies the delimiter to be inserted between split lines.
• The "TRUE" parameter indicates that the function will return a vertical array (i.e., multiple rows).
• "Text 1", "Text 2" and other parameters specify the text to be split.

Example:

To split "ABCDEF" into two characters per line, you can use the following formula:

<code>=TEXTJOIN(",", TRUE, MID("ABCDEF", 1, 2), MID("ABCDEF", 3, 2))</code>

Result:

<code>AB
CD</code>

You can use these methods to easily split a line of text into multiple lines in Excel as needed.

The above is the detailed content of How to divide a line of text into multiple lines in excel. For more information, please follow other related articles on the PHP Chinese website!