![excel split cells by line break excel split cells by line break](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Split-Cells-dialog-box.png)
dim txt as String dim stringarray() as String txtCells(1,1) stringarray Split(txt, vbCrLf) Cells(1,2.
#Excel split cells by line break how to#
Inserting line breaks in LibreOffice Writer text document tables does anyone know how to read a multiline string in excel cells and put each line into a string array for example in excell cells(1,1) ' option color option size option coating' i tried to use the following code but it doesn't work.
![excel split cells by line break excel split cells by line break](https://cdn.educba.com/academy/wp-content/uploads/2018/12/combine-cells-in-excel-1.png)
![excel split cells by line break excel split cells by line break](https://i.ytimg.com/vi/hL13sLI_5ew/maxresdefault.jpg)
So first double-click the cell, then single-click at the text position where you want the line break. This will work only with the text edit cursor inside the cell, not at the input line.