Forum Discussion
Solved
Delimiter for Separate Line Breaks in Cell not Working
I am trying to split a cell with three line breaks into 4 columns. When using the text to columns wizard and selecting delimited, all the text in the cell shows up in the preview. When I hit next, on...
HansVogelaar So I found a way to get it to work. All I did was edit the information that appears in the formula bar- like delete a word and then retype it-and somehow the text to column options works just fine.
In Step 2 of the wizard, tick the Other check box, then click in the box next to it and press Ctrl+J. This is the code for a line break.
I have done this however, the wizard is not recognizing any of my text after the first line break. So when I try to do ctrl+j, nothing happens.
Strange...
Instead of Ctrl+J, you can also try clicking in the box next to Other and pressing Alt+010 using the numeric keypad.
