Excel Guides

How to Automatically Break Text in Excel

If you have a lot of text in an Excel cell that is not wrapping correctly, you can automatically break it into multiple lines by using a simple formula. This can be very helpful if you are trying to create a specific format for your data or if you are working with cells that contain a lot of text.

To automatically break text in Excel, follow these steps:

  1. Select the cell or cells that you want to format.
  2. Click the Home tab.
  3. In the Alignment group, click the Wrap Text button.
  4. Enter the following formula into the cell: =LEFT(A1,FIND(" ",A1))
  5. Press Enter. The text in the cell will now be automatically broken into multiple lines.

You can also use this same method to automatically break text in other cells by referencing those cells in the formula. For example, if you wanted to automatically break text in cells A1 through A5, you would enter the following formula: =LEFT(A1:A5,FIND(" ",A1:A5))

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.