![excel split cells by line break excel split cells by line break](https://cdn.educba.com/academy/wp-content/uploads/2019/08/line-break-in-excel-1.png)
The bad news is that currently it’s a bit painful to do this.
EXCEL SPLIT CELLS BY LINE BREAK CODE
![excel split cells by line break excel split cells by line break](https://www.cedarville.edu/images/default-source/insights/parse-data-in-excel-spreadsheet.jpg)
It assumes that this is special text, so escapes it to text, and appends some commands that actually mess you up: Unfortunately, there is no line break or carriage return option in the dialog, which means that you’ll need to pick “Custom”, and enter the special character for a Line Feed:Įven worse, with entering this, Power Query is overly aggressive when you click OK.
![excel split cells by line break excel split cells by line break](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2012/07/one-column-to-two-columns-excel-2010-3.jpg)