Forum Discussion
Solved
How to split text to columns from newline?
I have cells that contain a newline in middle, as in the cell contents is: “Text1 Text2” I want to split it to: “Text1” and “Text2” Text to columns tool does not seem to have an option ...
- I read your question again.
If you want to use the "Text to columns tool" you can insert a linebreak with Ctrl+J (in "other delimiter" or whatever it's called in your version).
CHAR(10)
=TEXTSPLIT(A1,CHAR(10))
Thanks, that works.